{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Download historical equity data for NASDAQ stocks from yahoo finance"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-22T03:34:05.629047Z",
     "start_time": "2020-06-22T03:34:05.627196Z"
    }
   },
   "outputs": [],
   "source": [
    "import warnings\n",
    "warnings.filterwarnings('ignore')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-22T03:34:05.900193Z",
     "start_time": "2020-06-22T03:34:05.631054Z"
    }
   },
   "outputs": [],
   "source": [
    "from pathlib import Path\n",
    "import pandas as pd\n",
    "\n",
    "from pandas_datareader.nasdaq_trader import get_nasdaq_symbols\n",
    "import yfinance as yf"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-22T03:34:05.903150Z",
     "start_time": "2020-06-22T03:34:05.901358Z"
    }
   },
   "outputs": [],
   "source": [
    "idx = pd.IndexSlice"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "results_path = Path('results', 'asset_pricing')\n",
    "if not results_path.exists():\n",
    "    results_path.mkdir(parents=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-22T03:34:05.912831Z",
     "start_time": "2020-06-22T03:34:05.904458Z"
    }
   },
   "outputs": [],
   "source": [
    "def chunks(l, n): \n",
    "    for i in range(0, len(l), n):  \n",
    "        yield l[i:i + n] "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Get NASDAQ symbols"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-22T03:34:07.178921Z",
     "start_time": "2020-06-22T03:34:05.913926Z"
    }
   },
   "outputs": [],
   "source": [
    "traded_symbols = get_nasdaq_symbols()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-22T03:34:07.189639Z",
     "start_time": "2020-06-22T03:34:07.180276Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Index: 8895 entries, A to ZYXI\n",
      "Data columns (total 11 columns):\n",
      " #   Column            Non-Null Count  Dtype   \n",
      "---  ------            --------------  -----   \n",
      " 0   Nasdaq Traded     8895 non-null   bool    \n",
      " 1   Security Name     8895 non-null   object  \n",
      " 2   Listing Exchange  8895 non-null   category\n",
      " 3   Market Category   8895 non-null   object  \n",
      " 4   ETF               8895 non-null   bool    \n",
      " 5   Round Lot Size    8895 non-null   float64 \n",
      " 6   Test Issue        8895 non-null   bool    \n",
      " 7   Financial Status  3566 non-null   category\n",
      " 8   CQS Symbol        5329 non-null   object  \n",
      " 9   NASDAQ Symbol     8895 non-null   object  \n",
      " 10  NextShares        8895 non-null   bool    \n",
      "dtypes: bool(4), category(2), float64(1), object(4)\n",
      "memory usage: 469.5+ KB\n"
     ]
    }
   ],
   "source": [
    "traded_symbols.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Download metadata from yahoo finance"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### NASDAQ symbols"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-22T12:33:15.500384Z",
     "start_time": "2020-06-22T12:33:15.491375Z"
    }
   },
   "outputs": [],
   "source": [
    "all_tickers = traded_symbols[~traded_symbols.ETF].index.unique().to_list()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-22T03:34:36.149682Z",
     "start_time": "2020-06-22T03:34:07.191939Z"
    }
   },
   "outputs": [],
   "source": [
    "yf_tickers = yf.Tickers(all_tickers)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Currently, there's a `yfinance` [bug](https://github.com/ranaroussi/yfinance/issues/208) that causes some stock info downloads to fail; apply the workaround described in the comments or wait for a new release to get the full dataset. Currently, we are losing a few hundred."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-22T05:27:24.701265Z",
     "start_time": "2020-06-22T03:34:36.150986Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "list index out of range AAN\n",
      "list index out of range AAON\n",
      "list index out of range AAU\n",
      "list index out of range AB\n",
      "list index out of range ABC\n",
      "list index out of range ABCB\n",
      "list index out of range ABIO\n",
      "No tables found ABR$A\n",
      "No tables found ABR$B\n",
      "No tables found ABR$C\n",
      "No tables found ACAMW\n",
      "list index out of range ACB\n",
      "No tables found ACEL.W\n",
      "list index out of range ACGL\n",
      "list index out of range ACHV\n",
      "list index out of range ACLS\n",
      "list index out of range ACN\n",
      "list index out of range ACST\n",
      "No tables found ACTTW\n",
      "list index out of range ADCT\n",
      "list index out of range ADES\n",
      "No tables found ADILW\n",
      "list index out of range ADMP\n",
      "list index out of range ADXS\n",
      "list index out of range AE\n",
      "index 0 is out of bounds for axis 0 with size 0 AEB\n",
      "No tables found AEFC\n",
      "No tables found AEL$A\n",
      "list index out of range AEMD\n",
      "list index out of range AEO\n",
      "No tables found AEP$B\n",
      "list index out of range AEY\n",
      "list index out of range AEYE\n",
      "list index out of range AEZS\n",
      "No tables found AFC\n",
      "No tables found AFGB\n",
      "list index out of range AFGC\n",
      "list index out of range AFGD\n",
      "No tables found AFGH\n",
      "list index out of range AFH\n",
      "list index out of range AG\n",
      "list index out of range AGBA\n",
      "No tables found AGBAR\n",
      "No tables found AGBAW\n",
      "list index out of range AGEN\n",
      "No tables found AGFSW\n",
      "list index out of range AGM$A\n",
      "No tables found AGM$C\n",
      "No tables found AGM$D\n",
      "No tables found AGM$E\n",
      "list index out of range AGM.A\n",
      "No tables found AGO$B\n",
      "No tables found AGO$E\n",
      "list index out of range AGO$F\n",
      "No tables found AHH$A\n",
      "list index out of range AHL$C\n",
      "No tables found AHL$D\n",
      "No tables found AHL$E\n",
      "list index out of range AHPI\n",
      "No tables found AHT$D\n",
      "list index out of range AHT$F\n",
      "No tables found AHT$G\n",
      "No tables found AHT$H\n",
      "No tables found AHT$I\n",
      "list index out of range AI\n",
      "list index out of range AI$B\n",
      "list index out of range AI$C\n",
      "No tables found AIC\n",
      "list index out of range AIG\n",
      "list index out of range AIG$A\n",
      "list index out of range AIG.W\n",
      "list index out of range AINV\n",
      "list index out of range AIRI\n",
      "list index out of range AIRTP\n",
      "No tables found AIRTW\n",
      "list index out of range AIV\n",
      "list index out of range AIW\n",
      "index 0 is out of bounds for axis 0 with size 0 AJXA\n",
      "list index out of range AKER\n",
      "list index out of range AKO.A\n",
      "list index out of range AKO.B\n",
      "list index out of range AL$A\n",
      "No tables found ALACR\n",
      "list index out of range ALE\n",
      "list index out of range ALGN\n",
      "list index out of range ALIM\n",
      "No tables found ALIN$A\n",
      "list index out of range ALIN$B\n",
      "No tables found ALIN$E\n",
      "list index out of range ALL$B\n",
      "list index out of range ALL$G\n",
      "list index out of range ALL$H\n",
      "list index out of range ALL$I\n",
      "list index out of range ALLT\n",
      "No tables found ALLY$A\n",
      "No tables found ALP$Q\n",
      "list index out of range ALT\n",
      "No tables found ALTG.W\n",
      "No tables found ALUS.U\n",
      "No tables found ALUS.W\n",
      "list index out of range AMBC.W\n",
      "list index out of range AMBO\n",
      "No tables found AMCIW\n",
      "list index out of range AMH$D\n",
      "No tables found AMH$E\n",
      "list index out of range AMH$F\n",
      "No tables found AMH$G\n",
      "No tables found AMH$H\n",
      "No tables found AMHCW\n",
      "list index out of range AMRH\n",
      "No tables found AMRHW\n",
      "list index out of range AMRN\n",
      "list index out of range AMRS\n",
      "list index out of range AMSC\n",
      "list index out of range AMTD\n",
      "list index out of range AMTI\n",
      "list index out of range AMTX\n",
      "list index out of range ANAT\n",
      "No tables found ANDAR\n",
      "No tables found ANDAW\n",
      "list index out of range ANH$A\n",
      "list index out of range ANH$B\n",
      "list index out of range ANH$C\n",
      "list index out of range ANTE\n",
      "list index out of range ANTM\n",
      "list index out of range ANY\n",
      "list index out of range APDN\n",
      "list index out of range APEX\n",
      "list index out of range APH\n",
      "list index out of range APO\n",
      "list index out of range APO$A\n",
      "list index out of range APO$B\n",
      "list index out of range APOP\n",
      "No tables found APOPW\n",
      "list index out of range APRN\n",
      "list index out of range APTO\n",
      "list index out of range APTV\n",
      "No tables found APTV$A\n",
      "list index out of range APVO\n",
      "No tables found APXTW\n",
      "list index out of range APYX\n",
      "No tables found AQNA\n",
      "No tables found AQNB\n",
      "list index out of range ARCH\n",
      "list index out of range AREC\n",
      "No tables found ARES$A\n",
      "index 0 is out of bounds for axis 0 with size 0 ARGD\n",
      "list index out of range ARNA\n",
      "list index out of range ARNC\n",
      "list index out of range ARR\n",
      "list index out of range ARR$C\n",
      "list index out of range ARTL\n",
      "No tables found ARTLW\n",
      "list index out of range ARWR\n",
      "list index out of range ARYAU\n",
      "No tables found ARYAW\n",
      "list index out of range ARYBU\n",
      "list index out of range ASA\n",
      "No tables found ASB$C\n",
      "No tables found ASB$D\n",
      "No tables found ASB$E\n",
      "list index out of range ASB$F\n",
      "list index out of range ASG\n",
      "list index out of range ASM\n",
      "list index out of range ASML\n",
      "list index out of range ASNA\n",
      "list index out of range ASPU\n",
      "No tables found ASRVP\n",
      "list index out of range ASTC\n",
      "list index out of range ASYS\n",
      "list index out of range AT\n",
      "list index out of range ATCO\n",
      "No tables found ATCO$D\n",
      "No tables found ATCO$E\n",
      "No tables found ATCO$G\n",
      "No tables found ATCO$H\n",
      "No tables found ATCO$I\n",
      "No tables found ATCXW\n",
      "list index out of range ATEC\n",
      "No tables found ATEST\n",
      "list index out of range ATEST.A\n",
      "list index out of range ATEST.B\n",
      "list index out of range ATEST.C\n",
      "list index out of range ATH$A\n",
      "list index out of range ATH$B\n",
      "list index out of range ATH$C\n",
      "list index out of range ATI\n",
      "list index out of range ATIF\n",
      "list index out of range ATOS\n",
      "list index out of range ATRI\n",
      "list index out of range ATSG\n",
      "list index out of range ATV\n",
      "list index out of range ATXI\n",
      "list index out of range AU\n",
      "list index out of range AUBAP\n",
      "list index out of range AUTO\n",
      "list index out of range AVB\n",
      "No tables found AVCTW\n",
      "list index out of range AVGR\n",
      "list index out of range AVNW\n",
      "No tables found AVTR$A\n",
      "list index out of range AVXL\n",
      "list index out of range AXDX\n",
      "list index out of range AXGT\n",
      "No tables found AXO\n",
      "No tables found AXS$E\n",
      "list index out of range AY\n",
      "list index out of range AYLA\n",
      "list index out of range AYRO\n",
      "list index out of range AYTU\n",
      "list index out of range AZEK\n",
      "No tables found BAC$A\n",
      "No tables found BAC$B\n",
      "list index out of range BAC$C\n",
      "list index out of range BAC$E\n",
      "No tables found BAC$K\n",
      "list index out of range BAC$L\n",
      "No tables found BAC$M\n",
      "list index out of range BAC$N\n",
      "list index out of range BAM\n",
      "list index out of range BANC$D\n",
      "list index out of range BANC$E\n",
      "No tables found BANFP\n",
      "list index out of range BANR\n",
      "list index out of range BBD\n",
      "list index out of range BBL\n",
      "list index out of range BBVA\n",
      "list index out of range BC$A\n",
      "list index out of range BC$B\n",
      "list index out of range BC$C\n",
      "list index out of range BCDA\n",
      "No tables found BCDAW\n",
      "list index out of range BCE\n",
      "list index out of range BCLI\n",
      "list index out of range BCML\n",
      "list index out of range BCV$A\n",
      "list index out of range BDN\n",
      "list index out of range BDXB\n",
      "No tables found BEP$A\n",
      "No tables found BF.A\n",
      "'regularMarketOpen' BF.B\n",
      "No tables found BFS$D\n",
      "list index out of range BFS$E\n",
      "list index out of range BGH\n",
      "list index out of range BGI\n",
      "list index out of range BH.A\n",
      "index 0 is out of bounds for axis 0 with size 0 BHFAL\n",
      "list index out of range BHFAO\n",
      "list index out of range BHR\n",
      "list index out of range BHR$B\n",
      "No tables found BHR$D\n",
      "'regularMarketOpen' BIO.B\n",
      "list index out of range BIOC\n",
      "list index out of range BIOL\n",
      "No tables found BIOX.W\n",
      "list index out of range BK\n",
      "list index out of range BK$C\n",
      "list index out of range BKSC\n",
      "list index out of range BKYI\n",
      "list index out of range BLCM\n",
      "list index out of range BLFS\n",
      "list index out of range BLIN\n",
      "No tables found BLNKW\n",
      "list index out of range BLPH\n",
      "list index out of range BLRX\n",
      "list index out of range BLU\n",
      "No tables found BML$G\n",
      "No tables found BML$H\n",
      "No tables found BML$J\n",
      "No tables found BML$L\n",
      "list index out of range BMRA\n",
      "list index out of range BMRG\n",
      "No tables found BMRG.U\n",
      "No tables found BMRG.W\n",
      "list index out of range BMY\n",
      "list index out of range BMY.R\n",
      "No tables found BNGOW\n",
      "list index out of range BNR\n",
      "list index out of range BNSO\n",
      "HTTP Error 503: Service Unavailable BNTC\n",
      "list index out of range BOE\n",
      "list index out of range BOH\n",
      "list index out of range BOKFL\n",
      "list index out of range BORR\n",
      "list index out of range BOSC\n",
      "list index out of range BOTJ\n",
      "list index out of range BPOP\n",
      "list index out of range BPOPN\n",
      "list index out of range BPTH\n",
      "No tables found BRG$A\n",
      "list index out of range BRG$C\n",
      "list index out of range BRG$D\n",
      "No tables found BRK.A\n",
      "No tables found BRK.B\n",
      "list index out of range BRKL\n",
      "No tables found BRMK.W\n",
      "No tables found BROGW\n",
      "No tables found BRPAR\n",
      "list index out of range BRPAU\n",
      "No tables found BRPAW\n",
      "No tables found BSA\n",
      "list index out of range BSAC\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "list index out of range BSGM\n",
      "list index out of range BSQR\n",
      "list index out of range BSRR\n",
      "No tables found BSX$A\n",
      "list index out of range BTO\n",
      "list index out of range BTT\n",
      "list index out of range BUSE\n",
      "list index out of range BW\n",
      "list index out of range BWEN\n",
      "list index out of range BWFG\n",
      "list index out of range BWL.A\n",
      "list index out of range BXC\n",
      "No tables found BXP$B\n",
      "No tables found BXS$A\n",
      "list index out of range BZH\n",
      "list index out of range C\n",
      "list index out of range C$J\n",
      "list index out of range C$K\n",
      "list index out of range C$N\n",
      "list index out of range C$S\n",
      "list index out of range CACI\n",
      "list index out of range CAH\n",
      "list index out of range CAI$A\n",
      "list index out of range CAI$B\n",
      "list index out of range CAL\n",
      "list index out of range CALM\n",
      "list index out of range CALT\n",
      "list index out of range CANF\n",
      "list index out of range CAPR\n",
      "list index out of range CARE\n",
      "list index out of range CARV\n",
      "list index out of range CASH\n",
      "list index out of range CASS\n",
      "list index out of range CATB\n",
      "list index out of range CATO\n",
      "list index out of range CATS\n",
      "list index out of range CB\n",
      "list index out of range CBB\n",
      "list index out of range CBB$B\n",
      "list index out of range CBIO\n",
      "No tables found CBL$D\n",
      "No tables found CBL$E\n",
      "list index out of range CBLI\n",
      "No tables found CBO\n",
      "list index out of range CBRE\n",
      "list index out of range CBRL\n",
      "No tables found CBX\n",
      "list index out of range CCAC\n",
      "No tables found CCAC.U\n",
      "HTTP Error 503: Service Unavailable CCAC.W\n",
      "list index out of range CCB\n",
      "list index out of range CCCL\n",
      "list index out of range CCH.U\n",
      "list index out of range CCH.W\n",
      "No tables found CCI$A\n",
      "list index out of range CCK\n",
      "list index out of range CCL\n",
      "list index out of range CCNC\n",
      "list index out of range CCOI\n",
      "list index out of range CCR\n",
      "No tables found CCX.U\n",
      "No tables found CCX.W\n",
      "list index out of range CCXX\n",
      "No tables found CCXX.U\n",
      "No tables found CCXX.W\n",
      "No tables found CCZ\n",
      "list index out of range CDE\n",
      "list index out of range CDOR\n",
      "list index out of range CDR\n",
      "list index out of range CDR$B\n",
      "No tables found CDR$C\n",
      "list index out of range CDXC\n",
      "list index out of range CDZI\n",
      "list index out of range CECE\n",
      "list index out of range CEI\n",
      "list index out of range CELG.R\n",
      "list index out of range CELH\n",
      "list index out of range CEMI\n",
      "list index out of range CEQP\n",
      "list index out of range CEQP$\n",
      "list index out of range CETV\n",
      "list index out of range CETX\n",
      "list index out of range CETXP\n",
      "No tables found CETXW\n",
      "list index out of range CFBK\n",
      "No tables found CFFAW\n",
      "No tables found CFG$D\n",
      "list index out of range CFG$E\n",
      "list index out of range CFRX\n",
      "list index out of range CFXA\n",
      "list index out of range CGA\n",
      "list index out of range CGIX\n",
      "list index out of range CGRO\n",
      "list index out of range CGROU\n",
      "list index out of range CGROW\n",
      "list index out of range CHAQ\n",
      "No tables found CHAQ.U\n",
      "No tables found CHAQ.W\n",
      "list index out of range CHCI\n",
      "list index out of range CHE\n",
      "list index out of range CHEK\n",
      "No tables found CHEKZ\n",
      "list index out of range CHFS\n",
      "No tables found CHK\n",
      "No tables found CHK$D\n",
      "No tables found CHMI$A\n",
      "No tables found CHMI$B\n",
      "No tables found CHNGU\n",
      "list index out of range CHNR\n",
      "No tables found CHPMW\n",
      "list index out of range CHRW\n",
      "list index out of range CHT\n",
      "list index out of range CHX\n",
      "list index out of range CIB\n",
      "list index out of range CIDM\n",
      "list index out of range CIEN\n",
      "list index out of range CIF\n",
      "list index out of range CIG.C\n",
      "list index out of range CIH\n",
      "list index out of range CIIC\n",
      "No tables found CIICW\n",
      "list index out of range CIK\n",
      "list index out of range CIM\n",
      "No tables found CIM$A\n",
      "No tables found CIM$B\n",
      "list index out of range CIM$C\n",
      "No tables found CIM$D\n",
      "list index out of range CIO$A\n",
      "list index out of range CIT$B\n",
      "list index out of range CJJD\n",
      "list index out of range CLAR\n",
      "list index out of range CLBS\n",
      "list index out of range CLCT\n",
      "list index out of range CLDX\n",
      "list index out of range CLEU\n",
      "list index out of range CLF\n",
      "list index out of range CLFD\n",
      "list index out of range CLGN\n",
      "list index out of range CLI\n",
      "list index out of range CLM\n",
      "list index out of range CLNY\n",
      "No tables found CLNY$G\n",
      "No tables found CLNY$H\n",
      "No tables found CLNY$I\n",
      "No tables found CLNY$J\n",
      "list index out of range CLRB\n",
      "No tables found CLRBZ\n",
      "list index out of range CLRO\n",
      "list index out of range CLSK\n",
      "list index out of range CLSN\n",
      "list index out of range CLWT\n",
      "list index out of range CMCL\n",
      "list index out of range CMCSA\n",
      "list index out of range CMCT\n",
      "list index out of range CMCTP\n",
      "No tables found CMFNL\n",
      "list index out of range CMO\n",
      "No tables found CMO$E\n",
      "No tables found CMRE$B\n",
      "No tables found CMRE$C\n",
      "No tables found CMRE$D\n",
      "No tables found CMRE$E\n",
      "list index out of range CMS$B\n",
      "index 0 is out of bounds for axis 0 with size 0 CMSA\n",
      "index 0 is out of bounds for axis 0 with size 0 CMSC\n",
      "No tables found CMSD\n",
      "list index out of range CMTL\n",
      "list index out of range CMU\n",
      "list index out of range CNET\n",
      "index 0 is out of bounds for axis 0 with size 0 CNFRL\n",
      "list index out of range CNOB\n",
      "No tables found CNP$B\n",
      "list index out of range CNSL\n",
      "list index out of range CNTY\n",
      "list index out of range CO\n",
      "list index out of range COCP\n",
      "list index out of range CODA\n",
      "No tables found CODI$A\n",
      "No tables found CODI$B\n",
      "No tables found CODI$C\n",
      "list index out of range COF$F\n",
      "list index out of range COF$G\n",
      "list index out of range COF$H\n",
      "list index out of range COF$I\n",
      "list index out of range COF$J\n",
      "list index out of range COHN\n",
      "list index out of range COO\n",
      "list index out of range CORR\n",
      "No tables found CORR$A\n",
      "list index out of range COWN\n",
      "No tables found COWNL\n",
      "No tables found COWNZ\n",
      "No tables found CPAAW\n",
      "list index out of range CPAC\n",
      "list index out of range CPAH\n",
      "list index out of range CPF\n",
      "list index out of range CPLP\n",
      "list index out of range CPST\n",
      "No tables found CPTAG\n",
      "No tables found CPTAL\n",
      "list index out of range CRC\n",
      "list index out of range CRD.A\n",
      "No tables found CRD.B\n",
      "list index out of range CREG\n",
      "list index out of range CREX\n",
      "No tables found CREXW\n",
      "list index out of range CRF\n",
      "list index out of range CRIS\n",
      "No tables found CRM\n",
      "list index out of range CRMD\n",
      "No tables found CRSAW\n",
      "list index out of range CSBR\n",
      "No tables found CSWCL\n",
      "list index out of range CTA$A\n",
      "No tables found CTA$B\n",
      "No tables found CTAA\n",
      "index 0 is out of bounds for axis 0 with size 0 CTBB\n",
      "index 0 is out of bounds for axis 0 with size 0 CTDD\n",
      "No tables found CTEST\n",
      "list index out of range CTEST.E\n",
      "list index out of range CTEST.G\n",
      "list index out of range CTEST.L\n",
      "list index out of range CTEST.O\n",
      "list index out of range CTEST.S\n",
      "list index out of range CTEST.V\n",
      "list index out of range CTIB\n",
      "list index out of range CTIC\n",
      "list index out of range CTL\n",
      "list index out of range CTO\n",
      "list index out of range CTSO\n",
      "index 0 is out of bounds for axis 0 with size 0 CTV\n",
      "list index out of range CTXR\n",
      "No tables found CTXRW\n",
      "No tables found CTY\n",
      "index 0 is out of bounds for axis 0 with size 0 CTZ\n",
      "No tables found CUBB\n",
      "list index out of range CUBI$C\n",
      "No tables found CUBI$D\n",
      "No tables found CUBI$E\n",
      "list index out of range CUBI$F\n",
      "list index out of range CUTR\n",
      "list index out of range CUZ\n",
      "list index out of range CVM\n",
      "list index out of range CVU\n",
      "list index out of range CVX\n",
      "list index out of range CWCO\n",
      "list index out of range CWEN.A\n",
      "list index out of range CXE\n",
      "list index out of range CXH\n",
      "list index out of range CYAN\n",
      "list index out of range CYCC\n",
      "list index out of range CYCCP\n",
      "list index out of range CYRN\n",
      "list index out of range CYRX\n",
      "No tables found CYRXW\n",
      "list index out of range CYTK\n",
      "list index out of range DAC\n",
      "list index out of range DADA\n",
      "list index out of range DAO\n",
      "list index out of range DBCP\n",
      "list index out of range DBI\n",
      "No tables found DCP$B\n",
      "No tables found DCP$C\n",
      "list index out of range DCTH\n",
      "list index out of range DCUE\n",
      "list index out of range DD\n",
      "list index out of range DDD\n",
      "list index out of range DDS\n",
      "list index out of range DENN\n",
      "list index out of range DEO\n",
      "list index out of range DFFN\n",
      "list index out of range DFNS\n",
      "list index out of range DFNS.U\n",
      "No tables found DFNS.W\n",
      "list index out of range DFPH\n",
      "No tables found DFPHW\n",
      "list index out of range DGICB\n",
      "list index out of range DGLY\n",
      "No tables found DHCNI\n",
      "list index out of range DHCNL\n",
      "list index out of range DHIL\n",
      "list index out of range DHR\n",
      "No tables found DHR$A\n",
      "No tables found DHR$B\n",
      "list index out of range DHT\n",
      "list index out of range DIT\n",
      "list index out of range DK\n",
      "list index out of range DKNG\n",
      "No tables found DKNGW\n",
      "No tables found DLNG$A\n",
      "HTTP Error 503: Service Unavailable DLNG$B\n",
      "No tables found DLPNW\n",
      "No tables found DLR$C\n",
      "No tables found DLR$G\n",
      "No tables found DLR$I\n",
      "No tables found DLR$J\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "No tables found DLR$K\n",
      "No tables found DLR$L\n",
      "list index out of range DLY\n",
      "list index out of range DMAC\n",
      "list index out of range DMPI\n",
      "list index out of range DMYT\n",
      "No tables found DMYT.U\n",
      "No tables found DMYT.W\n",
      "list index out of range DNI\n",
      "list index out of range DNK\n",
      "list index out of range DNR\n",
      "No tables found DPHCW\n",
      "list index out of range DPW\n",
      "list index out of range DQ\n",
      "list index out of range DRAD\n",
      "list index out of range DRADP\n",
      "list index out of range DRD\n",
      "list index out of range DRE\n",
      "list index out of range DRIO\n",
      "No tables found DRIOW\n",
      "index 0 is out of bounds for axis 0 with size 0 DRUA\n",
      "list index out of range DS$B\n",
      "list index out of range DS$C\n",
      "list index out of range DS$D\n",
      "No tables found DSKEW\n",
      "list index out of range DSS\n",
      "list index out of range DSU\n",
      "No tables found DSX$B\n",
      "index 0 is out of bounds for axis 0 with size 0 DTJ\n",
      "list index out of range DTLA$\n",
      "No tables found DTP\n",
      "No tables found DTQ\n",
      "list index out of range DTSS\n",
      "index 0 is out of bounds for axis 0 with size 0 DTW\n",
      "index 0 is out of bounds for axis 0 with size 0 DTY\n",
      "list index out of range DUK\n",
      "No tables found DUK$A\n",
      "index 0 is out of bounds for axis 0 with size 0 DUKB\n",
      "index 0 is out of bounds for axis 0 with size 0 DUKH\n",
      "list index out of range DUOT\n",
      "list index out of range DVAX\n",
      "list index out of range DVD\n",
      "list index out of range DVN\n",
      "list index out of range DX\n",
      "list index out of range DX$B\n",
      "list index out of range DX$C\n",
      "list index out of range DXF\n",
      "list index out of range DXLG\n",
      "list index out of range DXPE\n",
      "list index out of range DYNT\n",
      "list index out of range DZSI\n",
      "No tables found EAB\n",
      "list index out of range EAD\n",
      "No tables found EAE\n",
      "index 0 is out of bounds for axis 0 with size 0 EAI\n",
      "list index out of range EARS\n",
      "list index out of range EAST\n",
      "No tables found EBAYL\n",
      "list index out of range EBIX\n",
      "list index out of range EBR.B\n",
      "index 0 is out of bounds for axis 0 with size 0 ECCX\n",
      "index 0 is out of bounds for axis 0 with size 0 ECCY\n",
      "No tables found ECF$A\n",
      "list index out of range ECOL\n",
      "No tables found ECOLW\n",
      "list index out of range EEX\n",
      "No tables found EFC$A\n",
      "list index out of range EFOI\n",
      "list index out of range EFSC\n",
      "list index out of range EGAN\n",
      "list index out of range EGHT\n",
      "list index out of range EGLE\n",
      "list index out of range EGO\n",
      "list index out of range EGP\n",
      "list index out of range EGY\n",
      "list index out of range EHI\n",
      "list index out of range EKSO\n",
      "list index out of range ELA\n",
      "No tables found ELAT\n",
      "index 0 is out of bounds for axis 0 with size 0 ELC\n",
      "list index out of range ELGX\n",
      "No tables found ELJ\n",
      "list index out of range ELLO\n",
      "list index out of range ELTK\n",
      "index 0 is out of bounds for axis 0 with size 0 ELU\n",
      "list index out of range EMAN\n",
      "list index out of range EMD\n",
      "list index out of range EMKR\n",
      "index 0 is out of bounds for axis 0 with size 0 EMP\n",
      "index 0 is out of bounds for axis 0 with size 0 ENBA\n",
      "index 0 is out of bounds for axis 0 with size 0 ENJ\n",
      "index 0 is out of bounds for axis 0 with size 0 ENO\n",
      "list index out of range ENOB\n",
      "No tables found ENR$A\n",
      "list index out of range ENSV\n",
      "list index out of range ENT\n",
      "No tables found ENTXW\n",
      "list index out of range EOD\n",
      "list index out of range EP$C\n",
      "list index out of range EPAC\n",
      "list index out of range EPIX\n",
      "No tables found EPR$C\n",
      "list index out of range EPR$E\n",
      "list index out of range EPR$G\n",
      "list index out of range EPSN\n",
      "list index out of range EQC\n",
      "No tables found EQC$D\n",
      "list index out of range EQH\n",
      "No tables found EQH$A\n",
      "list index out of range EQX\n",
      "list index out of range ERC\n",
      "list index out of range ERH\n",
      "list index out of range ERIC\n",
      "list index out of range ERJ\n",
      "list index out of range ESE\n",
      "list index out of range ESEA\n",
      "No tables found ESSCR\n",
      "No tables found ESSCW\n",
      "list index out of range ESTE\n",
      "list index out of range ETFC\n",
      "list index out of range ETI$\n",
      "list index out of range ETN\n",
      "list index out of range ETP$C\n",
      "No tables found ETP$D\n",
      "list index out of range ETP$E\n",
      "list index out of range ETR\n",
      "list index out of range EVBN\n",
      "list index out of range EVI\n",
      "list index out of range EVK\n",
      "list index out of range EVOL\n",
      "list index out of range EVSI\n",
      "No tables found EVSIW\n",
      "list index out of range EXAS\n",
      "list index out of range EXFO\n",
      "list index out of range EXP\n",
      "No tables found EXPCW\n",
      "list index out of range EXPE\n",
      "list index out of range EYEG\n",
      "No tables found EYEGW\n",
      "list index out of range EYES\n",
      "No tables found EYESW\n",
      "index 0 is out of bounds for axis 0 with size 0 EZT\n",
      "list index out of range F\n",
      "list index out of range F$B\n",
      "list index out of range F$C\n",
      "list index out of range FANH\n",
      "list index out of range FBC\n",
      "list index out of range FBIO\n",
      "list index out of range FBP\n",
      "list index out of range FBRX\n",
      "list index out of range FCEL\n",
      "list index out of range FCFS\n",
      "list index out of range FDBC\n",
      "No tables found FDUSG\n",
      "No tables found FDUSL\n",
      "No tables found FDUSZ\n",
      "list index out of range FDX\n",
      "list index out of range FEAC\n",
      "No tables found FEAC.U\n",
      "No tables found FEAC.W\n",
      "list index out of range FEN\n",
      "list index out of range FENC\n",
      "list index out of range FFC\n",
      "list index out of range FFHL\n",
      "list index out of range FGBI\n",
      "No tables found FHN$A\n",
      "No tables found FHN$E\n",
      "list index out of range FISI\n",
      "No tables found FLMNW\n",
      "list index out of range FLNG\n",
      "list index out of range FLNT\n",
      "list index out of range FLS\n",
      "list index out of range FLY\n",
      "list index out of range FMBIP\n",
      "list index out of range FMC\n",
      "No tables found FMCIW\n",
      "list index out of range FMTX\n",
      "No tables found FNB$E\n",
      "list index out of range FNHC\n",
      "list index out of range FNJN\n",
      "list index out of range FONR\n",
      "list index out of range FORD\n",
      "list index out of range FOSL\n",
      "list index out of range FOUR\n",
      "No tables found FPAC.U\n",
      "No tables found FPAC.W\n",
      "list index out of range FPAY\n",
      "No tables found FPI$B\n",
      "list index out of range FRAN\n",
      "list index out of range FRBK\n",
      "list index out of range FRC$F\n",
      "No tables found FRC$G\n",
      "list index out of range FRC$H\n",
      "No tables found FRC$I\n",
      "No tables found FRC$J\n",
      "list index out of range FRHC\n",
      "list index out of range FRO\n",
      "No tables found FRT$C\n",
      "list index out of range FSK\n",
      "No tables found FSKR\n",
      "No tables found FSRVW\n",
      "list index out of range FSV\n",
      "No tables found FTAI$A\n",
      "No tables found FTAI$B\n",
      "list index out of range FTSI\n",
      "list index out of range FTV$A\n",
      "list index out of range FUND\n",
      "No tables found FVAC.U\n",
      "list index out of range FVCB\n",
      "list index out of range FVE\n",
      "HTTP Error 503: Service Unavailable FWP\n",
      "list index out of range GAB$G\n",
      "list index out of range GAB$H\n",
      "No tables found GAB$J\n",
      "list index out of range GAB$K\n",
      "list index out of range GABC\n",
      "list index out of range GAIA\n",
      "list index out of range GALT\n",
      "list index out of range GAM$B\n",
      "list index out of range GAN\n",
      "list index out of range GAU\n",
      "list index out of range GBCI\n",
      "list index out of range GBIO\n",
      "No tables found GBLIL\n",
      "list index out of range GBLIZ\n",
      "list index out of range GBR\n",
      "list index out of range GD\n",
      "list index out of range GDL$C\n",
      "No tables found GDV$A\n",
      "No tables found GDV$G\n",
      "No tables found GDV$H\n",
      "No tables found GDYNW\n",
      "No tables found GECCL\n",
      "No tables found GECCM\n",
      "No tables found GECCN\n",
      "'regularMarketOpen' GEF.B\n",
      "list index out of range GENE\n",
      "list index out of range GEO\n",
      "list index out of range GER\n",
      "list index out of range GEVO\n",
      "list index out of range GFLU\n",
      "No tables found GFNSL\n",
      "list index out of range GFY\n",
      "list index out of range GGN\n",
      "No tables found GGN$B\n",
      "No tables found GGO$A\n",
      "No tables found GGT$E\n",
      "No tables found GGT$G\n",
      "No tables found GGZ$A\n",
      "list index out of range GHIV\n",
      "No tables found GHIVW\n",
      "list index out of range GIGM\n",
      "list index out of range GIK.U\n",
      "list index out of range GILT\n",
      "list index out of range GIX.R\n",
      "list index out of range GIX.U\n",
      "list index out of range GIX.W\n",
      "No tables found GJH\n",
      "No tables found GJO\n",
      "No tables found GJP\n",
      "No tables found GJR\n",
      "No tables found GJS\n",
      "No tables found GJT\n",
      "list index out of range GL$C\n",
      "index 0 is out of bounds for axis 0 with size 0 GLADD\n",
      "No tables found GLADL\n",
      "list index out of range GLBS\n",
      "list index out of range GLDD\n",
      "No tables found GLEO.U\n",
      "No tables found GLEO.W\n",
      "list index out of range GLG\n",
      "No tables found GLOG$A\n",
      "No tables found GLOP$A\n",
      "No tables found GLOP$B\n",
      "No tables found GLOP$C\n",
      "No tables found GLP$A\n",
      "No tables found GLU$A\n",
      "list index out of range GLU$B\n",
      "list index out of range GMBL\n",
      "No tables found GMBLW\n",
      "list index out of range GME\n",
      "list index out of range GMED\n",
      "No tables found GMHIW\n",
      "No tables found GMLPP\n",
      "list index out of range GMRE\n",
      "No tables found GMRE$A\n",
      "index 0 is out of bounds for axis 0 with size 0 GMTA\n",
      "list index out of range GMZ\n",
      "list index out of range GNCA\n",
      "No tables found GNE$A\n",
      "list index out of range GNK\n",
      "list index out of range GNL\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "No tables found GNL$A\n",
      "No tables found GNL$B\n",
      "list index out of range GNRS\n",
      "No tables found GNRSW\n",
      "list index out of range GNSS\n",
      "list index out of range GNT\n",
      "No tables found GNT$A\n",
      "list index out of range GNUS\n",
      "list index out of range GOF\n",
      "list index out of range GOGL\n",
      "list index out of range GOL\n",
      "list index out of range GOLD\n",
      "list index out of range GOODN\n",
      "No tables found GPAQW\n",
      "index 0 is out of bounds for axis 0 with size 0 GPJA\n",
      "list index out of range GPK\n",
      "list index out of range GPL\n",
      "list index out of range GPOR\n",
      "list index out of range GRAF.U\n",
      "list index out of range GRAF.W\n",
      "list index out of range GRBK\n",
      "list index out of range GRFS\n",
      "HTTP Error 503: Service Unavailable GRIL\n",
      "list index out of range GRMN\n",
      "No tables found GRNVR\n",
      "No tables found GRNVW\n",
      "list index out of range GRP.U\n",
      "list index out of range GRPN\n",
      "list index out of range GRVY\n",
      "No tables found GRX$B\n",
      "list index out of range GS$A\n",
      "list index out of range GS$C\n",
      "list index out of range GS$D\n",
      "list index out of range GS$J\n",
      "list index out of range GS$K\n",
      "list index out of range GS$N\n",
      "list index out of range GSK\n",
      "list index out of range GSL\n",
      "No tables found GSL$B\n",
      "No tables found GSLD\n",
      "list index out of range GSMGW\n",
      "list index out of range GSS\n",
      "list index out of range GSX\n",
      "list index out of range GTH\n",
      "list index out of range GTIM\n",
      "list index out of range GTN\n",
      "list index out of range GTN.A\n",
      "list index out of range GTY\n",
      "list index out of range GURE\n",
      "HTTP Error 503: Service Unavailable GUT\n",
      "list index out of range GUT$A\n",
      "list index out of range GUT$C\n",
      "No tables found GXGXW\n",
      "index 0 is out of bounds for axis 0 with size 0 GYC\n",
      "list index out of range HA\n",
      "list index out of range HAFC\n",
      "list index out of range HALL\n",
      "list index out of range HCACW\n",
      "No tables found HCAPZ\n",
      "No tables found HCCHR\n",
      "list index out of range HCCHU\n",
      "No tables found HCCHW\n",
      "No tables found HCCOW\n",
      "list index out of range HCFT\n",
      "list index out of range HCKT\n",
      "index 0 is out of bounds for axis 0 with size 0 HCXY\n",
      "index 0 is out of bounds for axis 0 with size 0 HCXZ\n",
      "list index out of range HE\n",
      "list index out of range HEAR\n",
      "list index out of range HECCU\n",
      "list index out of range HEI\n",
      "No tables found HEI.A\n",
      "list index out of range HELE\n",
      "list index out of range HEPA\n",
      "list index out of range HES\n",
      "list index out of range HEXO\n",
      "list index out of range HFC\n",
      "No tables found HFRO$A\n",
      "No tables found HGH\n",
      "list index out of range HGSH\n",
      "list index out of range HHS\n",
      "list index out of range HHT\n",
      "list index out of range HIBB\n",
      "list index out of range HIG$G\n",
      "list index out of range HIO\n",
      "list index out of range HIX\n",
      "No tables found HJLIW\n",
      "list index out of range HL$B\n",
      "list index out of range HLM$\n",
      "list index out of range HLT\n",
      "list index out of range HLX\n",
      "No tables found HMLP$A\n",
      "list index out of range HMY\n",
      "list index out of range HNGR\n",
      "list index out of range HNRG\n",
      "list index out of range HON\n",
      "list index out of range HOPE\n",
      "list index out of range HOV\n",
      "list index out of range HOVNP\n",
      "list index out of range HQH\n",
      "list index out of range HQI\n",
      "list index out of range HQL\n",
      "list index out of range HROW\n",
      "list index out of range HRTX\n",
      "list index out of range HSBC\n",
      "list index out of range HSBC$A\n",
      "list index out of range HSDT\n",
      "list index out of range HSKA\n",
      "list index out of range HSON\n",
      "list index out of range HST\n",
      "list index out of range HSTO\n",
      "list index out of range HT\n",
      "list index out of range HT$C\n",
      "list index out of range HT$D\n",
      "list index out of range HT$E\n",
      "list index out of range HTA\n",
      "list index out of range HTBX\n",
      "index 0 is out of bounds for axis 0 with size 0 HTFA\n",
      "list index out of range HTH\n",
      "list index out of range HTHT\n",
      "list index out of range HTZ\n",
      "No tables found HUGE\n",
      "list index out of range HVT.A\n",
      "list index out of range HWBK\n",
      "No tables found HWCPL\n",
      "No tables found HWCPZ\n",
      "list index out of range HWKN\n",
      "list index out of range HWM\n",
      "list index out of range HWM$\n",
      "list index out of range HXL\n",
      "No tables found HYACW\n",
      "list index out of range HYB\n",
      "list index out of range HYMC\n",
      "list index out of range HYMCW\n",
      "list index out of range HZNP\n",
      "list index out of range IAC\n",
      "list index out of range IAE\n",
      "list index out of range IART\n",
      "list index out of range IBCP\n",
      "list index out of range IBIO\n",
      "list index out of range IBKC\n",
      "No tables found IBO\n",
      "list index out of range ICAD\n",
      "list index out of range ICCC\n",
      "list index out of range ICD\n",
      "list index out of range ICL\n",
      "list index out of range ICMB\n",
      "list index out of range ICON\n",
      "list index out of range IDCC\n",
      "list index out of range IDE\n",
      "list index out of range IDEX\n",
      "list index out of range IDN\n",
      "list index out of range IDRA\n",
      "list index out of range IDT\n",
      "list index out of range IDXG\n",
      "No tables found IEAWW\n",
      "list index out of range IEC\n",
      "list index out of range IEP\n",
      "No tables found IFFT\n",
      "list index out of range IFS\n",
      "list index out of range IGA\n",
      "list index out of range IGC\n",
      "list index out of range IGD\n",
      "No tables found IGICW\n",
      "No tables found IGZ\n",
      "list index out of range IHC\n",
      "list index out of range IHD\n",
      "list index out of range IHG\n",
      "list index out of range IID\n",
      "list index out of range IIIN\n",
      "No tables found IIPR$A\n",
      "list index out of range IKNX\n",
      "No tables found IMACW\n",
      "list index out of range IMBI\n",
      "list index out of range IMH\n",
      "list index out of range IMKTA\n",
      "list index out of range IMOS\n",
      "list index out of range IMRN\n",
      "No tables found IMRNW\n",
      "No tables found INBKL\n",
      "No tables found INBKZ\n",
      "list index out of range INFU\n",
      "list index out of range INGR\n",
      "list index out of range INN$D\n",
      "list index out of range INN$E\n",
      "list index out of range INO\n",
      "list index out of range INOD\n",
      "list index out of range INPX\n",
      "list index out of range INS\n",
      "list index out of range INSI\n",
      "list index out of range INSM\n",
      "No tables found INSUW\n",
      "No tables found INSW$A\n",
      "list index out of range INT\n",
      "list index out of range INTL\n",
      "list index out of range INUV\n",
      "list index out of range INVE\n",
      "list index out of range IO\n",
      "list index out of range IOR\n",
      "list index out of range IOVA\n",
      "list index out of range IPDN\n",
      "HTTP Error 503: Service Unavailable IPHA\n",
      "list index out of range IPOB\n",
      "list index out of range IPOB.U\n",
      "list index out of range IPOB.W\n",
      "list index out of range IPOC\n",
      "list index out of range IPOC.U\n",
      "list index out of range IPOC.W\n",
      "list index out of range IPV\n",
      "No tables found IPV.U\n",
      "No tables found IPV.W\n",
      "list index out of range IPWR\n",
      "list index out of range IQI\n",
      "list index out of range IR\n",
      "list index out of range IRCP\n",
      "list index out of range IRET\n",
      "No tables found IRET$C\n",
      "list index out of range IRR\n",
      "list index out of range ISDR\n",
      "list index out of range ISR\n",
      "list index out of range ISRG\n",
      "list index out of range IT\n",
      "list index out of range ITCB\n",
      "list index out of range ITGR\n",
      "list index out of range ITI\n",
      "list index out of range ITP\n",
      "list index out of range ITUB\n",
      "No tables found IVR$A\n",
      "No tables found IVR$B\n",
      "No tables found IVR$C\n",
      "list index out of range IZEA\n",
      "list index out of range JACK\n",
      "list index out of range JAGX\n",
      "list index out of range JAN\n",
      "list index out of range JAZZ\n",
      "No tables found JBK\n",
      "No tables found JCAP$B\n",
      "list index out of range JCOM\n",
      "list index out of range JE$A\n",
      "No tables found JFKKR\n",
      "No tables found JFKKW\n",
      "list index out of range JHX\n",
      "No tables found JIH.U\n",
      "No tables found JIH.W\n",
      "list index out of range JMIA\n",
      "No tables found JMM\n",
      "index 0 is out of bounds for axis 0 with size 0 JMPNL\n",
      "No tables found JMPNZ\n",
      "list index out of range JOF\n",
      "list index out of range JPM\n",
      "list index out of range JPM$C\n",
      "list index out of range JPM$D\n",
      "list index out of range JPM$G\n",
      "list index out of range JPM$H\n",
      "list index out of range JPM$J\n",
      "list index out of range JRJC\n",
      "No tables found JSM\n",
      "No tables found JW.A\n",
      "list index out of range JW.B\n",
      "No tables found JWS.U\n",
      "list index out of range KBH\n",
      "No tables found KBLMR\n",
      "list index out of range KBLMU\n",
      "No tables found KBLMW\n",
      "list index out of range KBSF\n",
      "list index out of range KC\n",
      "No tables found KCAPL\n",
      "list index out of range KELYA\n",
      "list index out of range KELYB\n",
      "No tables found KERNW\n",
      "list index out of range KEY$I\n",
      "No tables found KEY$J\n",
      "list index out of range KEY$K\n",
      "list index out of range KF\n",
      "list index out of range KFS\n",
      "list index out of range KGC\n",
      "list index out of range KGJI\n",
      "No tables found KIM$L\n",
      "No tables found KIM$M\n",
      "list index out of range KINS\n",
      "list index out of range KIQ\n",
      "No tables found KKR$A\n",
      "No tables found KKR$B\n",
      "list index out of range KLR.W\n",
      "list index out of range KRG\n",
      "list index out of range KRKR\n",
      "list index out of range KROS\n",
      "list index out of range KSM\n",
      "list index out of range KSU\n",
      "list index out of range KSU$\n",
      "No tables found KTH\n",
      "No tables found KTN\n",
      "list index out of range KTOS\n",
      "No tables found KTOVW\n",
      "list index out of range LAC\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "list index out of range LACQU\n",
      "No tables found LACQW\n",
      "list index out of range LAMR\n",
      "list index out of range LARK\n",
      "No tables found LATNW\n",
      "list index out of range LC\n",
      "No tables found LCAHW\n",
      "list index out of range LCII\n",
      "list index out of range LCTX\n",
      "list index out of range LCUT\n",
      "list index out of range LEAF\n",
      "list index out of range LECO\n",
      "list index out of range LEDS\n",
      "list index out of range LEGN\n",
      "'regularMarketOpen' LEN.B\n",
      "No tables found LFACW\n",
      "list index out of range LFVN\n",
      "list index out of range LGC.U\n",
      "list index out of range LGC.W\n",
      "list index out of range LGF.A\n",
      "'regularMarketOpen' LGF.B\n",
      "list index out of range LGHL\n",
      "list index out of range LGHLW\n",
      "list index out of range LGND\n",
      "No tables found LGVW.U\n",
      "list index out of range LH\n",
      "list index out of range LHC.U\n",
      "list index out of range LHC.W\n",
      "list index out of range LHX\n",
      "list index out of range LIFE\n",
      "list index out of range LIQT\n",
      "list index out of range LIVE\n",
      "No tables found LIVKW\n",
      "list index out of range LJPC\n",
      "list index out of range LL\n",
      "list index out of range LLEX\n",
      "list index out of range LLIT\n",
      "list index out of range LMFA\n",
      "No tables found LMFAW\n",
      "index 0 is out of bounds for axis 0 with size 0 LMHA\n",
      "index 0 is out of bounds for axis 0 with size 0 LMHB\n",
      "No tables found LMRKN\n",
      "No tables found LMRKP\n",
      "list index out of range LNG\n",
      "No tables found LOACR\n",
      "No tables found LOACW\n",
      "list index out of range LOAK\n",
      "No tables found LOAK.U\n",
      "No tables found LOAK.W\n",
      "list index out of range LOAN\n",
      "list index out of range LODE\n",
      "list index out of range LOGI\n",
      "list index out of range LOOP\n",
      "list index out of range LPI\n",
      "list index out of range LPRO\n",
      "list index out of range LPTH\n",
      "list index out of range LRMR\n",
      "list index out of range LSAC\n",
      "No tables found LSACW\n",
      "list index out of range LTBR\n",
      "list index out of range LTRN\n",
      "list index out of range LTRX\n",
      "list index out of range LXP\n",
      "list index out of range LXP$C\n",
      "list index out of range LXRX\n",
      "list index out of range LYRA\n",
      "list index out of range LYV\n",
      "list index out of range M\n",
      "list index out of range MAA$I\n",
      "list index out of range MACK\n",
      "list index out of range MARA\n",
      "list index out of range MARK\n",
      "list index out of range MATX\n",
      "list index out of range MBOT\n",
      "list index out of range MCACU\n",
      "list index out of range MCEP\n",
      "list index out of range MCF\n",
      "list index out of range MCFT\n",
      "list index out of range MCI\n",
      "list index out of range MCK\n",
      "No tables found MCMJW\n",
      "list index out of range MCN\n",
      "list index out of range MCO\n",
      "No tables found MCV\n",
      "index 0 is out of bounds for axis 0 with size 0 MCX\n",
      "list index out of range MDCA\n",
      "list index out of range MDGS\n",
      "No tables found MDGSW\n",
      "index 0 is out of bounds for axis 0 with size 0 MDLQ\n",
      "index 0 is out of bounds for axis 0 with size 0 MDLX\n",
      "list index out of range MDLZ\n",
      "list index out of range MDRRP\n",
      "list index out of range MED\n",
      "list index out of range MEDS\n",
      "list index out of range MEIP\n",
      "list index out of range MER$K\n",
      "list index out of range MERC\n",
      "list index out of range MET$A\n",
      "list index out of range MET$E\n",
      "list index out of range MET$F\n",
      "list index out of range METX\n",
      "No tables found METXW\n",
      "list index out of range MFA\n",
      "No tables found MFA$B\n",
      "list index out of range MFA$C\n",
      "No tables found MFAC.U\n",
      "No tables found MFAC.W\n",
      "list index out of range MFGP\n",
      "list index out of range MFH\n",
      "list index out of range MFINL\n",
      "No tables found MFO\n",
      "list index out of range MGI\n",
      "list index out of range MGPI\n",
      "No tables found MGR\n",
      "list index out of range MH$A\n",
      "list index out of range MH$C\n",
      "list index out of range MH$D\n",
      "list index out of range MHF\n",
      "index 0 is out of bounds for axis 0 with size 0 MHLA\n",
      "No tables found MHNC\n",
      "list index out of range MICT\n",
      "list index out of range MINDP\n",
      "No tables found MITT$A\n",
      "No tables found MITT$B\n",
      "No tables found MITT$C\n",
      "list index out of range MKC.V\n",
      "list index out of range MKD\n",
      "list index out of range MKGI\n",
      "list index out of range MLAB\n",
      "index 0 is out of bounds for axis 0 with size 0 MLPY\n",
      "list index out of range MLR\n",
      "list index out of range MLSS\n",
      "list index out of range MMM\n",
      "list index out of range MMU\n",
      "list index out of range MMX\n",
      "No tables found MNCLW\n",
      "list index out of range MNKD\n",
      "list index out of range MNOV\n",
      "list index out of range MNP\n",
      "No tables found MNR$C\n",
      "list index out of range MNST\n",
      "list index out of range MOBL\n",
      "list index out of range MOFG\n",
      "No tables found MOG.A\n",
      "list index out of range MOG.B\n",
      "list index out of range MOGO\n",
      "list index out of range MOSY\n",
      "list index out of range MOXC\n",
      "list index out of range MPV\n",
      "list index out of range MR\n",
      "index 0 is out of bounds for axis 0 with size 0 MRCCL\n",
      "list index out of range MRIN\n",
      "list index out of range MRK\n",
      "list index out of range MRKR\n",
      "list index out of range MS\n",
      "list index out of range MS$A\n",
      "list index out of range MS$E\n",
      "list index out of range MS$F\n",
      "list index out of range MS$I\n",
      "list index out of range MS$K\n",
      "list index out of range MS$L\n",
      "list index out of range MSI\n",
      "list index out of range MSON\n",
      "list index out of range MSTR\n",
      "list index out of range MT\n",
      "list index out of range MTA\n",
      "list index out of range MTB\n",
      "list index out of range MTBCP\n",
      "No tables found MTCN\n",
      "list index out of range MTEX\n",
      "list index out of range MTH\n",
      "list index out of range MTL\n",
      "list index out of range MTL$\n",
      "list index out of range MTN\n",
      "list index out of range MTOR\n",
      "list index out of range MTP\n",
      "list index out of range MTRN\n",
      "list index out of range MTSL\n",
      "list index out of range MTW\n",
      "list index out of range MUFG\n",
      "list index out of range MVC\n",
      "index 0 is out of bounds for axis 0 with size 0 MVCD\n",
      "list index out of range MVIS\n",
      "list index out of range MYO\n",
      "list index out of range MYOS\n",
      "list index out of range MYSZ\n",
      "list index out of range MYT\n",
      "list index out of range NAII\n",
      "list index out of range NAKD\n",
      "list index out of range NARI\n",
      "list index out of range NATH\n",
      "list index out of range NAV\n",
      "list index out of range NAV$D\n",
      "list index out of range NAVB\n",
      "list index out of range NBAC\n",
      "No tables found NBACR\n",
      "No tables found NBACW\n",
      "list index out of range NBEV\n",
      "list index out of range NBL\n",
      "list index out of range NBR\n",
      "No tables found NBR$A\n",
      "list index out of range NBY\n",
      "list index out of range NCTY\n",
      "list index out of range NCV\n",
      "No tables found NCV$A\n",
      "list index out of range NCZ\n",
      "No tables found NCZ$A\n",
      "list index out of range NDP\n",
      "No tables found NDRAW\n",
      "list index out of range NEE\n",
      "list index out of range NEE$I\n",
      "No tables found NEE$J\n",
      "No tables found NEE$K\n",
      "No tables found NEE$N\n",
      "No tables found NEE$O\n",
      "No tables found NEE$P\n",
      "list index out of range NEO\n",
      "list index out of range NEON\n",
      "list index out of range NEPH\n",
      "list index out of range NEPT\n",
      "No tables found NESRW\n",
      "list index out of range NETE\n",
      "list index out of range NEU\n",
      "list index out of range NEWT\n",
      "No tables found NEWTI\n",
      "No tables found NEWTL\n",
      "list index out of range NEXA\n",
      "No tables found NFH.W\n",
      "No tables found NFINW\n",
      "list index out of range NGG\n",
      "No tables found NGHCZ\n",
      "No tables found NGL$B\n",
      "No tables found NGL$C\n",
      "No tables found NGLS$A\n",
      "list index out of range NHF\n",
      "list index out of range NHLD\n",
      "list index out of range NHLDW\n",
      "list index out of range NHS\n",
      "list index out of range NHTC\n",
      "list index out of range NI\n",
      "list index out of range NI$B\n",
      "list index out of range NIE\n",
      "list index out of range NIQ\n",
      "list index out of range NKLA\n",
      "list index out of range NKLAW\n",
      "list index out of range NKTR\n",
      "list index out of range NL\n",
      "list index out of range NLS\n",
      "list index out of range NLTX\n",
      "No tables found NLY$D\n",
      "No tables found NLY$F\n",
      "No tables found NLY$G\n",
      "No tables found NLY$I\n",
      "list index out of range NM\n",
      "No tables found NM$G\n",
      "list index out of range NM$H\n",
      "list index out of range NMFX\n",
      "No tables found NMK$B\n",
      "No tables found NMK$C\n",
      "list index out of range NMM\n",
      "list index out of range NMTR\n",
      "list index out of range NNA\n",
      "list index out of range NNBR\n",
      "list index out of range NNDM\n",
      "list index out of range NNN\n",
      "No tables found NNN$F\n",
      "list index out of range NNVC\n",
      "list index out of range NOG\n",
      "list index out of range NOVS\n",
      "list index out of range NOVSU\n",
      "list index out of range NOVSW\n",
      "list index out of range NOVT\n",
      "No tables found NPAWW\n",
      "list index out of range NR\n",
      "list index out of range NRP\n",
      "No tables found NRUC\n",
      "HTTP Error 503: Service Unavailable NRZ\n",
      "No tables found NRZ$A\n",
      "No tables found NRZ$B\n",
      "No tables found NRZ$C\n",
      "list index out of range NS$A\n",
      "No tables found NS$B\n",
      "list index out of range NS$C\n",
      "No tables found NSA$A\n",
      "No tables found NSCO.W\n",
      "list index out of range NSP\n",
      "list index out of range NSPR\n",
      "No tables found NSPR.B\n",
      "No tables found NSPR.W\n",
      "No tables found NSS\n",
      "list index out of range NTB\n",
      "No tables found NTEST\n",
      "list index out of range NTEST.A\n",
      "list index out of range NTEST.B\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "list index out of range NTEST.C\n",
      "list index out of range NTG\n",
      "list index out of range NTIC\n",
      "list index out of range NTN\n",
      "list index out of range NTP\n",
      "list index out of range NTRP\n",
      "list index out of range NTWK\n",
      "list index out of range NTZ\n",
      "list index out of range NURO\n",
      "list index out of range NUZE\n",
      "list index out of range NVAX\n",
      "list index out of range NVCN\n",
      "list index out of range NVEC\n",
      "list index out of range NVFY\n",
      "list index out of range NVGS\n",
      "list index out of range NVIV\n",
      "list index out of range NWGI\n",
      "list index out of range NWL\n",
      "list index out of range NXTD\n",
      "No tables found NYCB$A\n",
      "No tables found NYCB$U\n",
      "list index out of range NYMT\n",
      "list index out of range OAC.U\n",
      "list index out of range OAC.W\n",
      "No tables found OAK$A\n",
      "list index out of range OAK$B\n",
      "list index out of range OBAS\n",
      "list index out of range OBLG\n",
      "list index out of range OBLN\n",
      "list index out of range OCC\n",
      "list index out of range OCCIP\n",
      "list index out of range OCFC\n",
      "list index out of range OCFCP\n",
      "list index out of range OCFT\n",
      "list index out of range OCN\n",
      "list index out of range OCSI\n",
      "list index out of range OCSL\n",
      "list index out of range OEG\n",
      "list index out of range OFC\n",
      "No tables found OFG$A\n",
      "list index out of range OFG$B\n",
      "No tables found OFG$D\n",
      "No tables found OFSSI\n",
      "No tables found OFSSL\n",
      "index 0 is out of bounds for axis 0 with size 0 OFSSZ\n",
      "list index out of range OGEN\n",
      "list index out of range OGI\n",
      "list index out of range OIBR.C\n",
      "list index out of range OKE\n",
      "list index out of range OMC\n",
      "list index out of range OMEX\n",
      "list index out of range OMI\n",
      "list index out of range ONCS\n",
      "list index out of range ONCY\n",
      "list index out of range ONTX\n",
      "No tables found ONTXW\n",
      "list index out of range OPBK\n",
      "list index out of range OPCH\n",
      "No tables found OPESW\n",
      "list index out of range OPGN\n",
      "list index out of range OPHC\n",
      "list index out of range OPI\n",
      "list index out of range OPINI\n",
      "list index out of range OPNT\n",
      "list index out of range OPRX\n",
      "list index out of range OPTT\n",
      "list index out of range OPY\n",
      "list index out of range ORAN\n",
      "list index out of range ORGS\n",
      "list index out of range ORIC\n",
      "list index out of range ORMP\n",
      "No tables found ORSNR\n",
      "No tables found ORSNW\n",
      "list index out of range OSB\n",
      "list index out of range OSG\n",
      "list index out of range OSN\n",
      "list index out of range OSUR\n",
      "list index out of range OTLK\n",
      "No tables found OTLKW\n",
      "list index out of range OUT\n",
      "list index out of range OVV\n",
      "list index out of range OXBRW\n",
      "list index out of range OXLCO\n",
      "No tables found OXSQL\n",
      "No tables found OXSQZ\n",
      "list index out of range OZK\n",
      "list index out of range PACD\n",
      "No tables found PACK.W\n",
      "No tables found PACQW\n",
      "list index out of range PACW\n",
      "No tables found PAEWW\n",
      "list index out of range PAGP\n",
      "list index out of range PAI\n",
      "list index out of range PANL\n",
      "list index out of range PARR\n",
      "list index out of range PATI\n",
      "list index out of range PAVMW\n",
      "No tables found PAVMZ\n",
      "list index out of range PAYS\n",
      "index 0 is out of bounds for axis 0 with size 0 PBB\n",
      "No tables found PBC\n",
      "list index out of range PBI$B\n",
      "list index out of range PBR.A\n",
      "index 0 is out of bounds for axis 0 with size 0 PBY\n",
      "No tables found PCG$A\n",
      "No tables found PCG$B\n",
      "No tables found PCG$C\n",
      "No tables found PCG$D\n",
      "No tables found PCG$E\n",
      "No tables found PCG$G\n",
      "No tables found PCG$H\n",
      "No tables found PCG$I\n",
      "list index out of range PCH\n",
      "list index out of range PCOM\n",
      "list index out of range PCPL\n",
      "No tables found PCPL.U\n",
      "No tables found PCPL.W\n",
      "list index out of range PCVX\n",
      "list index out of range PCYG\n",
      "list index out of range PCYO\n",
      "list index out of range PDEX\n",
      "list index out of range PDI\n",
      "list index out of range PEAK\n",
      "list index out of range PEB$C\n",
      "No tables found PEB$D\n",
      "No tables found PEB$E\n",
      "list index out of range PEB$F\n",
      "list index out of range PEBK\n",
      "list index out of range PED\n",
      "list index out of range PEG\n",
      "list index out of range PEI$B\n",
      "No tables found PEI$C\n",
      "list index out of range PEI$D\n",
      "list index out of range PEIX\n",
      "list index out of range PERI\n",
      "list index out of range PESI\n",
      "list index out of range PFBC\n",
      "list index out of range PFIN\n",
      "list index out of range PFSW\n",
      "list index out of range PGEN\n",
      "list index out of range PHG\n",
      "No tables found PHGE.U\n",
      "No tables found PHGE.W\n",
      "list index out of range PHIO\n",
      "list index out of range PHIOW\n",
      "list index out of range PHM\n",
      "No tables found PHUNW\n",
      "list index out of range PIC.U\n",
      "list index out of range PIC.W\n",
      "list index out of range PICO\n",
      "list index out of range PIHPP\n",
      "list index out of range PIXY\n",
      "No tables found PJH\n",
      "list index out of range PKI\n",
      "list index out of range PLAG\n",
      "list index out of range PLG\n",
      "list index out of range PLL\n",
      "list index out of range PLM\n",
      "list index out of range PLRX\n",
      "list index out of range PLT\n",
      "list index out of range PLUG\n",
      "list index out of range PLX\n",
      "No tables found PLYM$A\n",
      "list index out of range PMD\n",
      "No tables found PMT$A\n",
      "No tables found PMT$B\n",
      "list index out of range PNBK\n",
      "list index out of range PNC$P\n",
      "No tables found PNC$Q\n",
      "list index out of range PNFPP\n",
      "No tables found PNNTG\n",
      "list index out of range PNR\n",
      "list index out of range PNRG\n",
      "list index out of range PNW\n",
      "list index out of range POAI\n",
      "list index out of range POL\n",
      "list index out of range PPBI\n",
      "list index out of range PPIH\n",
      "list index out of range PPL\n",
      "list index out of range PPR\n",
      "list index out of range PPSI\n",
      "No tables found PPX\n",
      "list index out of range PRA\n",
      "list index out of range PRDO\n",
      "list index out of range PRE$F\n",
      "list index out of range PRE$G\n",
      "list index out of range PRE$H\n",
      "list index out of range PRE$I\n",
      "list index out of range PRGX\n",
      "No tables found PRH\n",
      "No tables found PRIF$A\n",
      "No tables found PRIF$B\n",
      "No tables found PRIF$C\n",
      "No tables found PRIF$D\n",
      "No tables found PRIF$E\n",
      "No tables found PRIF$F\n",
      "list index out of range PRMW\n",
      "list index out of range PROF\n",
      "list index out of range PROG\n",
      "list index out of range PRPO\n",
      "index 0 is out of bounds for axis 0 with size 0 PRS\n",
      "No tables found PSA$B\n",
      "No tables found PSA$C\n",
      "No tables found PSA$D\n",
      "No tables found PSA$E\n",
      "No tables found PSA$F\n",
      "No tables found PSA$G\n",
      "No tables found PSA$H\n",
      "No tables found PSA$I\n",
      "No tables found PSA$J\n",
      "No tables found PSA$K\n",
      "No tables found PSA$L\n",
      "No tables found PSA$V\n",
      "No tables found PSA$W\n",
      "list index out of range PSA$X\n",
      "No tables found PSB$W\n",
      "list index out of range PSB$X\n",
      "No tables found PSB$Y\n",
      "No tables found PSB$Z\n",
      "list index out of range PSHG\n",
      "list index out of range PSTI\n",
      "list index out of range PSTV\n",
      "list index out of range PTAC\n",
      "No tables found PTACW\n",
      "list index out of range PTE\n",
      "list index out of range PTEN\n",
      "index 0 is out of bounds for axis 0 with size 0 PTMN\n",
      "list index out of range PTN\n",
      "list index out of range PTVCA\n",
      "list index out of range PTVCB\n",
      "list index out of range PUK$\n",
      "No tables found PUK$A\n",
      "list index out of range PULM\n",
      "list index out of range PVL\n",
      "list index out of range PW\n",
      "list index out of range PW$A\n",
      "list index out of range PXD\n",
      "list index out of range PXLW\n",
      "index 0 is out of bounds for axis 0 with size 0 PYS\n",
      "No tables found PYT\n",
      "list index out of range QDEL\n",
      "list index out of range QGEN\n",
      "list index out of range QLGN\n",
      "list index out of range QMCO\n",
      "list index out of range QQQX\n",
      "list index out of range QRHC\n",
      "No tables found QTS$A\n",
      "No tables found QTS$B\n",
      "list index out of range QUIK\n",
      "list index out of range QUOT\n",
      "No tables found QVCC\n",
      "index 0 is out of bounds for axis 0 with size 0 QVCD\n",
      "list index out of range RACE\n",
      "list index out of range RAD\n",
      "list index out of range RADA\n",
      "list index out of range RAND\n",
      "list index out of range RAVE\n",
      "list index out of range RBCN\n",
      "list index out of range RBNC\n",
      "No tables found RCA\n",
      "No tables found RCB\n",
      "list index out of range RCG\n",
      "list index out of range RCI\n",
      "list index out of range RCM\n",
      "list index out of range RCMT\n",
      "list index out of range RCON\n",
      "No tables found RCP\n",
      "list index out of range RDCM\n",
      "list index out of range RDI\n",
      "list index out of range RDIB\n",
      "list index out of range RDN\n",
      "list index out of range RDNT\n",
      "No tables found RDS.A\n",
      "'regularMarketOpen' RDS.B\n",
      "list index out of range RE\n",
      "list index out of range REKR\n",
      "list index out of range RELV\n",
      "list index out of range RELX\n",
      "list index out of range RENN\n",
      "list index out of range RESI\n",
      "list index out of range REV\n",
      "list index out of range REX\n",
      "list index out of range REXN\n",
      "No tables found REXR$A\n",
      "No tables found REXR$B\n",
      "No tables found REXR$C\n",
      "list index out of range RF$A\n",
      "No tables found RF$B\n",
      "list index out of range RF$C\n",
      "list index out of range RFIL\n",
      "list index out of range RFM\n",
      "list index out of range RFP\n",
      "list index out of range RGA\n",
      "list index out of range RGLS\n",
      "list index out of range RHE\n",
      "list index out of range RHE$A\n",
      "list index out of range RHI\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "list index out of range RHP\n",
      "list index out of range RIBT\n",
      "list index out of range RIG\n",
      "list index out of range RIGL\n",
      "No tables found RILYG\n",
      "No tables found RILYH\n",
      "index 0 is out of bounds for axis 0 with size 0 RILYI\n",
      "No tables found RILYM\n",
      "No tables found RILYN\n",
      "No tables found RILYO\n",
      "list index out of range RILYP\n",
      "No tables found RILYZ\n",
      "list index out of range RIO\n",
      "list index out of range RIOT\n",
      "list index out of range RJF\n",
      "list index out of range RKDA\n",
      "list index out of range RL\n",
      "list index out of range RLGT\n",
      "list index out of range RLH\n",
      "No tables found RLJ$A\n",
      "list index out of range RLMD\n",
      "list index out of range RMBL\n",
      "list index out of range RMCF\n",
      "list index out of range RMG.U\n",
      "list index out of range RMG.W\n",
      "list index out of range RMPL$\n",
      "list index out of range RNA\n",
      "No tables found RNR$E\n",
      "list index out of range RNR$F\n",
      "list index out of range RNST\n",
      "list index out of range RNWK\n",
      "list index out of range ROCH\n",
      "list index out of range ROCHU\n",
      "list index out of range ROCHW\n",
      "list index out of range ROIC\n",
      "list index out of range ROSEU\n",
      "No tables found ROSEW\n",
      "list index out of range RPLA.U\n",
      "No tables found RPLA.W\n",
      "list index out of range RPRX\n",
      "list index out of range RPT\n",
      "No tables found RPT$D\n",
      "list index out of range RPTX\n",
      "list index out of range RRC\n",
      "list index out of range RRD\n",
      "list index out of range RSF\n",
      "list index out of range RSSS\n",
      "list index out of range RTRX\n",
      "list index out of range RTW\n",
      "list index out of range RUSHB\n",
      "list index out of range RWLK\n",
      "list index out of range RY$T\n",
      "list index out of range RYAAY\n",
      "list index out of range RYCE\n",
      "No tables found RZA\n",
      "index 0 is out of bounds for axis 0 with size 0 RZB\n",
      "list index out of range SA\n",
      "No tables found SACC\n",
      "index 0 is out of bounds for axis 0 with size 0 SAF\n",
      "list index out of range SALT\n",
      "No tables found SAMAW\n",
      "list index out of range SAN\n",
      "list index out of range SAN$B\n",
      "list index out of range SAND\n",
      "list index out of range SANM\n",
      "No tables found SAQNW\n",
      "list index out of range SAR\n",
      "list index out of range SB$C\n",
      "list index out of range SB$D\n",
      "No tables found SBBA\n",
      "list index out of range SBCF\n",
      "list index out of range SBE.U\n",
      "list index out of range SBE.W\n",
      "list index out of range SBFG\n",
      "list index out of range SBI\n",
      "list index out of range SBLK\n",
      "No tables found SBLKZ\n",
      "index 0 is out of bounds for axis 0 with size 0 SCA\n",
      "No tables found SCCB\n",
      "No tables found SCE$B\n",
      "No tables found SCE$C\n",
      "No tables found SCE$D\n",
      "No tables found SCE$E\n",
      "list index out of range SCE$G\n",
      "list index out of range SCE$H\n",
      "No tables found SCE$J\n",
      "No tables found SCE$K\n",
      "list index out of range SCE$L\n",
      "list index out of range SCHW$C\n",
      "list index out of range SCHW$D\n",
      "list index out of range SCKT\n",
      "list index out of range SCON\n",
      "No tables found SCPE.U\n",
      "No tables found SCPE.W\n",
      "list index out of range SCU\n",
      "list index out of range SCVX\n",
      "No tables found SCVX.U\n",
      "No tables found SCVX.W\n",
      "list index out of range SDPI\n",
      "list index out of range SEB\n",
      "list index out of range SEE\n",
      "list index out of range SEED\n",
      "list index out of range SENEB\n",
      "list index out of range SENS\n",
      "list index out of range SESN\n",
      "list index out of range SF$A\n",
      "list index out of range SF$B\n",
      "list index out of range SF$C\n",
      "index 0 is out of bounds for axis 0 with size 0 SFB\n",
      "list index out of range SFE\n",
      "list index out of range SFET\n",
      "list index out of range SFST\n",
      "No tables found SFTW.U\n",
      "No tables found SFTW.W\n",
      "list index out of range SFUN\n",
      "list index out of range SGA\n",
      "list index out of range SGBX\n",
      "list index out of range SGLB\n",
      "No tables found SGLBW\n",
      "list index out of range SGMS\n",
      "list index out of range SGOC\n",
      "list index out of range SGRP\n",
      "list index out of range SHI\n",
      "list index out of range SHIP\n",
      "list index out of range SHIPW\n",
      "No tables found SHIPZ\n",
      "list index out of range SHLL.U\n",
      "No tables found SHLL.W\n",
      "list index out of range SHO$E\n",
      "list index out of range SHO$F\n",
      "list index out of range SHSP\n",
      "list index out of range SIEB\n",
      "list index out of range SIFY\n",
      "list index out of range SIG\n",
      "list index out of range SINT\n",
      "list index out of range SITC\n",
      "No tables found SITC$A\n",
      "No tables found SITC$K\n",
      "list index out of range SIVBP\n",
      "list index out of range SJ\n",
      "No tables found SJIJ\n",
      "No tables found SJIU\n",
      "list index out of range SJM\n",
      "list index out of range SKM\n",
      "list index out of range SKYS\n",
      "list index out of range SLCT\n",
      "list index out of range SLG$I\n",
      "list index out of range SLGG\n",
      "list index out of range SLNO\n",
      "list index out of range SLQT\n",
      "list index out of range SLS\n",
      "list index out of range SMBK\n",
      "list index out of range SMFG\n",
      "list index out of range SMIT\n",
      "list index out of range SMM\n",
      "No tables found SMMCW\n",
      "list index out of range SMMF\n",
      "list index out of range SMSI\n",
      "list index out of range SMTS\n",
      "list index out of range SMTX\n",
      "list index out of range SNBR\n",
      "list index out of range SNCA\n",
      "list index out of range SNDR\n",
      "list index out of range SNES\n",
      "list index out of range SNGX\n",
      "No tables found SNGXW\n",
      "list index out of range SNMP\n",
      "list index out of range SNN\n",
      "list index out of range SNOA\n",
      "list index out of range SNSS\n",
      "list index out of range SNV\n",
      "No tables found SNV$D\n",
      "No tables found SNV$E\n",
      "No tables found SOAC.U\n",
      "list index out of range SOHO\n",
      "index 0 is out of bounds for axis 0 with size 0 SOJA\n",
      "index 0 is out of bounds for axis 0 with size 0 SOJB\n",
      "index 0 is out of bounds for axis 0 with size 0 SOJC\n",
      "No tables found SOJD\n",
      "list index out of range SOL\n",
      "No tables found SOLN\n",
      "list index out of range SOLO\n",
      "No tables found SOLOW\n",
      "list index out of range SONN\n",
      "No tables found SPAQ.U\n",
      "No tables found SPAQ.W\n",
      "list index out of range SPCB\n",
      "list index out of range SPE\n",
      "list index out of range SPE$B\n",
      "list index out of range SPG\n",
      "No tables found SPG$J\n",
      "list index out of range SPGI\n",
      "list index out of range SPI\n",
      "list index out of range SPKEP\n",
      "No tables found SPLP$A\n",
      "list index out of range SPN\n",
      "list index out of range SPPI\n",
      "list index out of range SPRT\n",
      "list index out of range SPTN\n",
      "list index out of range SQNS\n",
      "list index out of range SR\n",
      "list index out of range SR$A\n",
      "No tables found SRACW\n",
      "list index out of range SRC\n",
      "No tables found SRC$A\n",
      "list index out of range SRE$A\n",
      "No tables found SRE$B\n",
      "No tables found SREA\n",
      "No tables found SRG$A\n",
      "list index out of range SRL\n",
      "list index out of range SRNE\n",
      "list index out of range SRPT\n",
      "list index out of range SRRA\n",
      "list index out of range SRTS\n",
      "list index out of range SRV\n",
      "list index out of range SSB\n",
      "list index out of range SSKN\n",
      "list index out of range SSL\n",
      "list index out of range SSNT\n",
      "list index out of range SSP\n",
      "No tables found SSPKW\n",
      "list index out of range SSSS\n",
      "list index out of range SSY\n",
      "list index out of range STAA\n",
      "list index out of range STAF\n",
      "list index out of range STAG$C\n",
      "list index out of range STAR\n",
      "list index out of range STAR$D\n",
      "list index out of range STAR$G\n",
      "list index out of range STAR$I\n",
      "list index out of range STCN\n",
      "list index out of range STE\n",
      "list index out of range STKL\n",
      "list index out of range STKS\n",
      "list index out of range STL\n",
      "No tables found STL$A\n",
      "list index out of range STM\n",
      "list index out of range STMP\n",
      "list index out of range STN\n",
      "list index out of range STNG\n",
      "list index out of range STRL\n",
      "list index out of range STRM\n",
      "list index out of range STRS\n",
      "list index out of range STT\n",
      "list index out of range STT$D\n",
      "No tables found STT$G\n",
      "list index out of range STX\n",
      "list index out of range STXS\n",
      "list index out of range STZ\n",
      "'regularMarketOpen' STZ.B\n",
      "list index out of range SUMR\n",
      "list index out of range SUNW\n",
      "list index out of range SURF\n",
      "list index out of range SUZ\n",
      "list index out of range SVA\n",
      "list index out of range SVC\n",
      "list index out of range SVM\n",
      "list index out of range SWBI\n",
      "list index out of range SWKH\n",
      "No tables found SWT\n",
      "list index out of range SYBT\n",
      "No tables found SYF$A\n",
      "list index out of range SYN\n",
      "list index out of range SYNH\n",
      "list index out of range SYPR\n",
      "list index out of range SYX\n",
      "list index out of range SZC\n",
      "list index out of range T$A\n",
      "list index out of range T$C\n",
      "list index out of range TA\n",
      "list index out of range TACOW\n",
      "list index out of range TAK\n",
      "No tables found TALO.W\n",
      "No tables found TANNI\n",
      "No tables found TANNL\n",
      "No tables found TANNZ\n",
      "list index out of range TAOP\n",
      "list index out of range TAP\n",
      "list index out of range TAP.A\n",
      "list index out of range TARA\n",
      "list index out of range TAT\n",
      "list index out of range TATT\n",
      "No tables found TBB\n",
      "No tables found TBC\n",
      "list index out of range TBI\n",
      "list index out of range TBK\n",
      "list index out of range TBLT\n",
      "No tables found TBLTW\n",
      "list index out of range TCBIL\n",
      "list index out of range TCI\n",
      "No tables found TCO$J\n",
      "No tables found TCO$K\n",
      "list index out of range TCOM\n",
      "list index out of range TCON\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "No tables found TCRW\n",
      "index 0 is out of bounds for axis 0 with size 0 TCRZ\n",
      "list index out of range TCX\n",
      "No tables found TDA\n",
      "No tables found TDACW\n",
      "No tables found TDE\n",
      "No tables found TDI\n",
      "No tables found TDJ\n",
      "list index out of range TDS\n",
      "list index out of range TDW.A\n",
      "'regularMarketOpen' TDW.B\n",
      "list index out of range TDW.W\n",
      "list index out of range TEF\n",
      "list index out of range TEL\n",
      "list index out of range TENX\n",
      "list index out of range TERP\n",
      "list index out of range TEUM\n",
      "list index out of range TEX\n",
      "list index out of range TFC\n",
      "list index out of range TFC$F\n",
      "No tables found TFC$G\n",
      "No tables found TFC$H\n",
      "No tables found TFC$I\n",
      "list index out of range TFC$O\n",
      "list index out of range TGA\n",
      "list index out of range TGC\n",
      "list index out of range TGLS\n",
      "list index out of range TGNA\n",
      "No tables found TGP$A\n",
      "No tables found TGP$B\n",
      "list index out of range TGT\n",
      "list index out of range TGTX\n",
      "No tables found THBRW\n",
      "list index out of range THC\n",
      "No tables found THCAW\n",
      "No tables found THCBW\n",
      "list index out of range THG\n",
      "No tables found THGA\n",
      "list index out of range THMO\n",
      "list index out of range THRM\n",
      "No tables found THWWW\n",
      "list index out of range TIGO\n",
      "list index out of range TILE\n",
      "list index out of range TIPT\n",
      "list index out of range TK\n",
      "list index out of range TKAT\n",
      "list index out of range TKC\n",
      "list index out of range TLF\n",
      "list index out of range TLGT\n",
      "list index out of range TLI\n",
      "list index out of range TLND\n",
      "list index out of range TMBR\n",
      "list index out of range TMDI\n",
      "list index out of range TME\n",
      "list index out of range TMHC\n",
      "list index out of range TMP\n",
      "list index out of range TMQ\n",
      "list index out of range TNDM\n",
      "list index out of range TNK\n",
      "No tables found TNP$C\n",
      "No tables found TNP$D\n",
      "No tables found TNP$E\n",
      "No tables found TNP$F\n",
      "list index out of range TNXP\n",
      "list index out of range TOPS\n",
      "No tables found TOTAR\n",
      "No tables found TOTAW\n",
      "list index out of range TPC\n",
      "list index out of range TPCO\n",
      "list index out of range TPR\n",
      "index 0 is out of bounds for axis 0 with size 0 TPVY\n",
      "list index out of range TRCH\n",
      "No tables found TREB.U\n",
      "list index out of range TREC\n",
      "list index out of range TRI\n",
      "list index out of range TRIB\n",
      "list index out of range TRIL\n",
      "list index out of range TRMD\n",
      "list index out of range TRMK\n",
      "list index out of range TRNE.U\n",
      "No tables found TRNE.W\n",
      "list index out of range TRPX\n",
      "list index out of range TRQ\n",
      "list index out of range TRT\n",
      "No tables found TRTN$A\n",
      "No tables found TRTN$B\n",
      "No tables found TRTN$C\n",
      "No tables found TRTN$D\n",
      "list index out of range TRV\n",
      "list index out of range TRX\n",
      "list index out of range TRXC\n",
      "list index out of range TSEM\n",
      "list index out of range TSRI\n",
      "list index out of range TSU\n",
      "list index out of range TT\n",
      "list index out of range TTEC\n",
      "list index out of range TTNP\n",
      "list index out of range TTP\n",
      "list index out of range TTPH\n",
      "list index out of range TU\n",
      "list index out of range TURN\n",
      "No tables found TVC\n",
      "No tables found TVE\n",
      "list index out of range TVTY\n",
      "list index out of range TWMC\n",
      "list index out of range TWNK\n",
      "list index out of range TWNKW\n",
      "list index out of range TWO\n",
      "No tables found TWO$A\n",
      "No tables found TWO$B\n",
      "list index out of range TWO$C\n",
      "list index out of range TWO$D\n",
      "No tables found TWO$E\n",
      "list index out of range TY$\n",
      "list index out of range TYG\n",
      "list index out of range TYL\n",
      "No tables found TZACW\n",
      "list index out of range TZOO\n",
      "list index out of range UAL\n",
      "list index out of range UBP\n",
      "No tables found UBP$H\n",
      "No tables found UBP$K\n",
      "list index out of range UCBI\n",
      "list index out of range UCBIO\n",
      "list index out of range UCL\n",
      "list index out of range UEPS\n",
      "list index out of range UFCS\n",
      "list index out of range UFI\n",
      "list index out of range UFS\n",
      "list index out of range UI\n",
      "list index out of range UIS\n",
      "list index out of range UL\n",
      "list index out of range UMC\n",
      "No tables found UMH$B\n",
      "No tables found UMH$C\n",
      "No tables found UMH$D\n",
      "list index out of range UMPQ\n",
      "list index out of range UN\n",
      "list index out of range UNF\n",
      "list index out of range UNH\n",
      "list index out of range UNIT\n",
      "index 0 is out of bounds for axis 0 with size 0 UNMA\n",
      "list index out of range UONE\n",
      "list index out of range UONEK\n",
      "list index out of range USA\n",
      "list index out of range USAU\n",
      "list index out of range USB\n",
      "No tables found USB$A\n",
      "No tables found USB$H\n",
      "No tables found USB$M\n",
      "No tables found USB$O\n",
      "No tables found USB$P\n",
      "list index out of range USEG\n",
      "list index out of range USIO\n",
      "list index out of range USLM\n",
      "No tables found USWSW\n",
      "list index out of range UTSI\n",
      "list index out of range UUU\n",
      "list index out of range UUUU\n",
      "No tables found UUUU.W\n",
      "list index out of range UVE\n",
      "No tables found UZA\n",
      "index 0 is out of bounds for axis 0 with size 0 UZB\n",
      "No tables found UZC\n",
      "list index out of range VAL\n",
      "list index out of range VALE\n",
      "list index out of range VAR\n",
      "list index out of range VBFC\n",
      "list index out of range VBIV\n",
      "list index out of range VCEL\n",
      "list index out of range VEDL\n",
      "list index out of range VER\n",
      "list index out of range VER$F\n",
      "list index out of range VERB\n",
      "No tables found VERBW\n",
      "list index out of range VERT.U\n",
      "list index out of range VERU\n",
      "list index out of range VGR\n",
      "list index out of range VGZ\n",
      "list index out of range VHC\n",
      "list index out of range VHI\n",
      "list index out of range VIAC\n",
      "list index out of range VIACA\n",
      "list index out of range VIAV\n",
      "list index out of range VISL\n",
      "list index out of range VIV\n",
      "list index out of range VIVE\n",
      "No tables found VKTXW\n",
      "list index out of range VLGEA\n",
      "list index out of range VLO\n",
      "list index out of range VNCE\n",
      "list index out of range VNO\n",
      "No tables found VNO$K\n",
      "No tables found VNO$L\n",
      "list index out of range VNO$M\n",
      "list index out of range VNRX\n",
      "list index out of range VOD\n",
      "list index out of range VOXX\n",
      "list index out of range VOYA\n",
      "list index out of range VOYA$B\n",
      "list index out of range VRM\n",
      "No tables found VRME\n",
      "list index out of range VRMEW\n",
      "No tables found VRT.W\n",
      "list index out of range VST\n",
      "list index out of range VST.A\n",
      "list index out of range VTGN\n",
      "list index out of range VTOL\n",
      "list index out of range VTR\n",
      "list index out of range VTSI\n",
      "list index out of range VUZI\n",
      "list index out of range VVI\n",
      "list index out of range VVNT\n",
      "No tables found VVNT.W\n",
      "list index out of range VVUS\n",
      "No tables found VXZ\n",
      "list index out of range VZ\n",
      "list index out of range WABC\n",
      "list index out of range WAFU\n",
      "index 0 is out of bounds for axis 0 with size 0 WALA\n",
      "No tables found WBS$F\n",
      "list index out of range WBT\n",
      "list index out of range WELL\n",
      "list index out of range WEN\n",
      "list index out of range WETF\n",
      "list index out of range WFC\n",
      "list index out of range WFC$L\n",
      "No tables found WFC$N\n",
      "No tables found WFC$O\n",
      "list index out of range WFC$P\n",
      "No tables found WFC$Q\n",
      "No tables found WFC$R\n",
      "No tables found WFC$T\n",
      "No tables found WFC$V\n",
      "No tables found WFC$W\n",
      "list index out of range WFC$X\n",
      "No tables found WFC$Y\n",
      "No tables found WFC$Z\n",
      "index 0 is out of bounds for axis 0 with size 0 WHFBZ\n",
      "list index out of range WHLM\n",
      "list index out of range WHLR\n",
      "list index out of range WIMI\n",
      "list index out of range WINA\n",
      "list index out of range WINT\n",
      "list index out of range WISA\n",
      "list index out of range WKEY\n",
      "list index out of range WKHS\n",
      "list index out of range WLL\n",
      "list index out of range WM\n",
      "list index out of range WMG\n",
      "No tables found WPF.U\n",
      "list index out of range WPG\n",
      "list index out of range WPG$H\n",
      "No tables found WPG$I\n",
      "list index out of range WPM\n",
      "list index out of range WPP\n",
      "list index out of range WPRT\n",
      "No tables found WRB$B\n",
      "No tables found WRB$C\n",
      "No tables found WRB$D\n",
      "No tables found WRB$E\n",
      "No tables found WRB$F\n",
      "list index out of range WRI\n",
      "list index out of range WSBF\n",
      "list index out of range WSO.B\n",
      "list index out of range WST\n",
      "list index out of range WSTG\n",
      "list index out of range WSTL\n",
      "No tables found WTER\n",
      "list index out of range WTFCP\n",
      "list index out of range WTM\n",
      "list index out of range WTREP\n",
      "list index out of range WTRG\n",
      "No tables found WTRU\n",
      "list index out of range WTT\n",
      "list index out of range WVVIP\n",
      "list index out of range WW\n",
      "list index out of range WWR\n",
      "list index out of range X\n",
      "list index out of range XAIR\n",
      "No tables found XAN$C\n",
      "list index out of range XBIO\n",
      "No tables found XBIOW\n",
      "list index out of range XEL\n",
      "list index out of range XELB\n",
      "list index out of range XOM\n",
      "list index out of range XOMA\n",
      "list index out of range XPER\n",
      "list index out of range XPL\n",
      "list index out of range XPO\n",
      "list index out of range XRAY\n",
      "list index out of range XRF\n",
      "list index out of range XSPA\n",
      "list index out of range XTLB\n",
      "list index out of range XTNT\n",
      "No tables found YCBD$A\n",
      "list index out of range YGYI\n",
      "list index out of range YGYIP\n",
      "list index out of range YRCW\n",
      "list index out of range YTEN\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "list index out of range YTRA\n",
      "list index out of range YUM\n",
      "list index out of range YVR\n",
      "list index out of range ZAGG\n",
      "No tables found ZAZZT\n",
      "No tables found ZBZX\n",
      "No tables found ZBZZT\n",
      "No tables found ZCZZT\n",
      "No tables found ZEXIT\n",
      "list index out of range ZGNX\n",
      "list index out of range ZGYH\n",
      "No tables found ZGYHR\n",
      "list index out of range ZGYHU\n",
      "No tables found ZGYHW\n",
      "list index out of range ZI\n",
      "list index out of range ZIEXT\n",
      "index 0 is out of bounds for axis 0 with size 0 ZIONL\n",
      "list index out of range ZIOP\n",
      "list index out of range ZIXI\n",
      "No tables found ZJZZT\n",
      "list index out of range ZNTL\n",
      "No tables found ZNWAA\n",
      "list index out of range ZOM\n",
      "list index out of range ZSAN\n",
      "No tables found ZTEST\n",
      "list index out of range ZTO\n",
      "list index out of range ZVO\n",
      "No tables found ZVV\n",
      "No tables found ZVZZC\n",
      "No tables found ZVZZT\n",
      "No tables found ZWZZT\n",
      "No tables found ZXIET\n",
      "list index out of range ZXYZ.A\n",
      "No tables found ZXZZT\n",
      "list index out of range ZYXI\n"
     ]
    }
   ],
   "source": [
    "info = []\n",
    "for ticker in yf_tickers.tickers:\n",
    "    try:\n",
    "        info.append(pd.Series(ticker.info).to_frame(ticker.ticker))\n",
    "    except Exception as e:\n",
    "        print(e, ticker.ticker)\n",
    "info = pd.concat(info, axis=1).dropna(how='all').T\n",
    "info = info.apply(pd.to_numeric, errors='ignore')\n",
    "info.to_hdf(results_path / 'data.h5', 'stocks/info')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Download adjusted price data using yfinance"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-22T12:42:21.146786Z",
     "start_time": "2020-06-22T12:33:18.424434Z"
    },
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "7 Failed downloads:\n",
      "- ABR$C: No data found, symbol may be delisted\n",
      "- ADILW: 1d data not available for startTime=-2208988800 and endTime=1592829199. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- ABR$A: No data found, symbol may be delisted\n",
      "- ACTTW: 1d data not available for startTime=-2208988800 and endTime=1592829200. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- ACAMW: 1d data not available for startTime=-2208988800 and endTime=1592829201. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- ABR$B: No data found, symbol may be delisted\n",
      "- ACEL.W: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "26 Failed downloads:\n",
      "- AHT$F: No data found, symbol may be delisted\n",
      "- AGO$B: No data found, symbol may be delisted\n",
      "- AGBAR: 1d data not available for startTime=-2208988800 and endTime=1592829210. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- AHT$G: No data found, symbol may be delisted\n",
      "- AI$B: No data found, symbol may be delisted\n",
      "- AGFSW: 1d data not available for startTime=-2208988800 and endTime=1592829210. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- AGBAW: 1d data not available for startTime=-2208988800 and endTime=1592829210. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- AGM$A: No data found, symbol may be delisted\n",
      "- AHT$D: No data found, symbol may be delisted\n",
      "- AHH$A: No data found, symbol may be delisted\n",
      "- AEP$B: No data found, symbol may be delisted\n",
      "- AHL$E: No data found, symbol may be delisted\n",
      "- AGM$C: No data found, symbol may be delisted\n",
      "- AHT$H: No data found, symbol may be delisted\n",
      "- AHL$C: No data found, symbol may be delisted\n",
      "- AGO$E: No data found, symbol may be delisted\n",
      "- AHL$D: No data found, symbol may be delisted\n",
      "- AIG.W: No data found, symbol may be delisted\n",
      "- AI$C: No data found, symbol may be delisted\n",
      "- AEL$A: No data found, symbol may be delisted\n",
      "- AGM$E: No data found, symbol may be delisted\n",
      "- AIG$A: No data found, symbol may be delisted\n",
      "- AHT$I: No data found, symbol may be delisted\n",
      "- AGO$F: No data found, symbol may be delisted\n",
      "- AGM.A: No data found, symbol may be delisted\n",
      "- AGM$D: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "18 Failed downloads:\n",
      "- AMBC.W: No data found, symbol may be delisted\n",
      "- ALL$H: No data found, symbol may be delisted\n",
      "- ALIN$B: No data found, symbol may be delisted\n",
      "- AKO.B: No data found, symbol may be delisted\n",
      "- ALL$I: No data found, symbol may be delisted\n",
      "- ALUS.U: No data found, symbol may be delisted\n",
      "- AKO.A: No data found, symbol may be delisted\n",
      "- ALL$B: No data found, symbol may be delisted\n",
      "- ALP$Q: No data found, symbol may be delisted\n",
      "- ALACW: 1d data not available for startTime=-2208988800 and endTime=1592829220. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- ALL$G: No data found, symbol may be delisted\n",
      "- AL$A: No data found, symbol may be delisted\n",
      "- AIRTW: 1d data not available for startTime=-2208988800 and endTime=1592829221. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- ALTG.W: No data found, symbol may be delisted\n",
      "- ALIN$A: No data found, symbol may be delisted\n",
      "- ALUS.W: No data found, symbol may be delisted\n",
      "- ALLY$A: No data found, symbol may be delisted\n",
      "- ALIN$E: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "15 Failed downloads:\n",
      "- ANDAR: 1d data not available for startTime=-2208988800 and endTime=1592829227. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- ANH$B: No data found, symbol may be delisted\n",
      "- ANH$C: No data found, symbol may be delisted\n",
      "- ANH$A: No data found, symbol may be delisted\n",
      "- AMH$H: No data found, symbol may be delisted\n",
      "- APO$B: No data found, symbol may be delisted\n",
      "- AMH$E: No data found, symbol may be delisted\n",
      "- AMRHW: 1d data not available for startTime=-2208988800 and endTime=1592829229. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- AMCIW: 1d data not available for startTime=-2208988800 and endTime=1592829230. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- AMHCW: 1d data not available for startTime=-2208988800 and endTime=1592829230. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- AMH$F: No data found, symbol may be delisted\n",
      "- ANDAW: 1d data not available for startTime=-2208988800 and endTime=1592829230. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- APO$A: No data found, symbol may be delisted\n",
      "- AMH$D: No data found, symbol may be delisted\n",
      "- AMH$G: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "11 Failed downloads:\n",
      "- ARTLW: 1d data not available for startTime=-2208988800 and endTime=1592829232. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- ASB$E: No data found, symbol may be delisted\n",
      "- APXTW: 1d data not available for startTime=-2208988800 and endTime=1592829233. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- ARES$A: No data found, symbol may be delisted\n",
      "- APOPW: 1d data not available for startTime=-2208988800 and endTime=1592829233. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- ARR$C: No data found, symbol may be delisted\n",
      "- ASB$D: No data found, symbol may be delisted\n",
      "- ASB$F: No data found, symbol may be delisted\n",
      "- APTV$A: No data found, symbol may be delisted\n",
      "- ASB$C: No data found, symbol may be delisted\n",
      "- ARYAW: 1d data not available for startTime=-2208988800 and endTime=1592829235. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "15 Failed downloads:\n",
      "- ATEST.B: No data found, symbol may be delisted\n",
      "- AVCTW: 1d data not available for startTime=-2208988800 and endTime=1592829237. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- ATCO$G: No data found, symbol may be delisted\n",
      "- AVTR$A: No data found, symbol may be delisted\n",
      "- ATEST.A: No data found, symbol may be delisted\n",
      "- ATCO$I: No data found, symbol may be delisted\n",
      "- ATEST.C: No data found, symbol may be delisted\n",
      "- ATEST: 1d data not available for startTime=-2208988800 and endTime=1592829238. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- ATCO$H: No data found, symbol may be delisted\n",
      "- ATH$B: No data found, symbol may be delisted\n",
      "- ATH$C: No data found, symbol may be delisted\n",
      "- ATCXW: 1d data not available for startTime=-2208988800 and endTime=1592829239. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- ATH$A: No data found, symbol may be delisted\n",
      "- ATCO$D: No data found, symbol may be delisted\n",
      "- ATCO$E: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "15 Failed downloads:\n",
      "- BC$C: No data found, symbol may be delisted\n",
      "- BAC$M: No data found, symbol may be delisted\n",
      "- BAC$B: No data found, symbol may be delisted\n",
      "- BAC$N: No data found, symbol may be delisted\n",
      "- BAC$L: No data found, symbol may be delisted\n",
      "- BANC$D: No data found, symbol may be delisted\n",
      "- BAC$C: No data found, symbol may be delisted\n",
      "- BC$A: No data found, symbol may be delisted\n",
      "- BCDAW: 1d data not available for startTime=-2208988800 and endTime=1592829243. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- AXS$E: No data found, symbol may be delisted\n",
      "- BC$B: No data found, symbol may be delisted\n",
      "- BAC$K: No data found, symbol may be delisted\n",
      "- BAC$A: No data found, symbol may be delisted\n",
      "- BANC$E: No data found, symbol may be delisted\n",
      "- BAC$E: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "11 Failed downloads:\n",
      "- BF.B: 1d data not available for startTime=-2208988800 and endTime=1592829252. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- BFS$E: No data found, symbol may be delisted\n",
      "- BF.A: No data found, symbol may be delisted\n",
      "- BHR$D: No data found, symbol may be delisted\n",
      "- BIO.B: 1d data not available for startTime=-2208988800 and endTime=1592829253. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- BH.A: No data found, symbol may be delisted\n",
      "- BFS$D: No data found, symbol may be delisted\n",
      "- BCV$A: No data found, symbol may be delisted\n",
      "- BEP$A: No data found, symbol may be delisted\n",
      "- BIOX.W: No data found, symbol may be delisted\n",
      "- BHR$B: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "10 Failed downloads:\n",
      "- BMRG.W: No data found, symbol may be delisted\n",
      "- BLNKW: 1d data not available for startTime=-2208988800 and endTime=1592829263. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- BMY.R: No data found, symbol may be delisted\n",
      "- BML$J: No data found, symbol may be delisted\n",
      "- BML$G: No data found, symbol may be delisted\n",
      "- BNGOW: 1d data not available for startTime=-2208988800 and endTime=1592829264. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- BML$H: No data found, symbol may be delisted\n",
      "- BK$C: No data found, symbol may be delisted\n",
      "- BML$L: No data found, symbol may be delisted\n",
      "- BMRG.U: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "12 Failed downloads:\n",
      "- BRK.A: No data found, symbol may be delisted\n",
      "- BSX$A: No data found, symbol may be delisted\n",
      "- BRG$D: No data found, symbol may be delisted\n",
      "- BWL.A: No data found, symbol may be delisted\n",
      "- BRPAW: 1d data not available for startTime=-2208988800 and endTime=1592829274. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- BXP$B: No data found, symbol may be delisted\n",
      "- BRG$C: No data found, symbol may be delisted\n",
      "- BXS$A: No data found, symbol may be delisted\n",
      "- BRK.B: No data found, symbol may be delisted\n",
      "- BRMK.W: No data found, symbol may be delisted\n",
      "- BROGW: 1d data not available for startTime=-2208988800 and endTime=1592829276. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- BRG$A: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "11 Failed downloads:\n",
      "- CBL$E: No data found, symbol may be delisted\n",
      "- CCAC.W: No data found, symbol may be delisted\n",
      "- CAI$A: No data found, symbol may be delisted\n",
      "- CBB$B: No data found, symbol may be delisted\n",
      "- C$S: No data found, symbol may be delisted\n",
      "- CCAC.U: No data found, symbol may be delisted\n",
      "- CAI$B: No data found, symbol may be delisted\n",
      "- C$N: No data found, symbol may be delisted\n",
      "- CBL$D: No data found, symbol may be delisted\n",
      "- C$J: No data found, symbol may be delisted\n",
      "- C$K: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "15 Failed downloads:\n",
      "- CCI$A: No data found, symbol may be delisted\n",
      "- CCX.W: No data found, symbol may be delisted\n",
      "- CCXX.W: No data found, symbol may be delisted\n",
      "- CDR$C: No data found, symbol may be delisted\n",
      "- CCXX.U: No data found, symbol may be delisted\n",
      "- CFG$D: No data found, symbol may be delisted\n",
      "- CELG.R: No data found, symbol may be delisted\n",
      "- CFFAW: 1d data not available for startTime=-2208988800 and endTime=1592829294. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- CCH.U: No data found, symbol may be delisted\n",
      "- CETXW: 1d data not available for startTime=-2208988800 and endTime=1592829295. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- CFG$E: No data found, symbol may be delisted\n",
      "- CCX.U: No data found, symbol may be delisted\n",
      "- CEQP$: No data found, symbol may be delisted\n",
      "- CCH.W: No data found, symbol may be delisted\n",
      "- CDR$B: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "18 Failed downloads:\n",
      "- CIG.C: No data found, symbol may be delisted\n",
      "- CHMI$B: No data found, symbol may be delisted\n",
      "- CIO$A: No data found, symbol may be delisted\n",
      "- CIICW: 1d data not available for startTime=-2208988800 and endTime=1592829303. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- CHK$D: No data found, symbol may be delisted\n",
      "- CHAQ.W: No data found, symbol may be delisted\n",
      "- CIT$B: No data found, symbol may be delisted\n",
      "- CIM$C: No data found, symbol may be delisted\n",
      "- CHMI$A: No data found, symbol may be delisted\n",
      "- CHAQ: No data found, symbol may be delisted\n",
      "- CIM$A: No data found, symbol may be delisted\n",
      "- CIM$D: No data found, symbol may be delisted\n",
      "- CHEKZ: 1d data not available for startTime=-2208988800 and endTime=1592829305. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- CGRO: No data found, symbol may be delisted\n",
      "- CGROW: No data found, symbol may be delisted\n",
      "- CHAQ.U: No data found, symbol may be delisted\n",
      "- CIM$B: No data found, symbol may be delisted\n",
      "- CHPMW: 1d data not available for startTime=-2208988800 and endTime=1592829305. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "13 Failed downloads:\n",
      "- CLNY$H: No data found, symbol may be delisted\n",
      "- CLRBZ: 1d data not available for startTime=-2208988800 and endTime=1592829307. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- CMFNL: 1d data not available for startTime=-2208988800 and endTime=1592829307. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- CLNY$I: No data found, symbol may be delisted\n",
      "- CLNY$G: No data found, symbol may be delisted\n",
      "- CMRE$B: No data found, symbol may be delisted\n",
      "- CMRE$E: No data found, symbol may be delisted\n",
      "- CMS$B: No data found, symbol may be delisted\n",
      "- CNP$B: No data found, symbol may be delisted\n",
      "- CMRE$C: No data found, symbol may be delisted\n",
      "- CMRE$D: No data found, symbol may be delisted\n",
      "- CMO$E: No data found, symbol may be delisted\n",
      "- CLNY$J: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "13 Failed downloads:\n",
      "- COF$I: No data found, symbol may be delisted\n",
      "- CREXW: 1d data not available for startTime=-2208988800 and endTime=1592829318. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- CODI$B: No data found, symbol may be delisted\n",
      "- CRD.A: No data found, symbol may be delisted\n",
      "- COF$H: No data found, symbol may be delisted\n",
      "- COF$J: No data found, symbol may be delisted\n",
      "- CPAAW: 1d data not available for startTime=-2208988800 and endTime=1592829319. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- CODI$A: No data found, symbol may be delisted\n",
      "- CRD.B: No data found, symbol may be delisted\n",
      "- CODI$C: No data found, symbol may be delisted\n",
      "- COF$G: No data found, symbol may be delisted\n",
      "- CORR$A: No data found, symbol may be delisted\n",
      "- COF$F: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "15 Failed downloads:\n",
      "- CTEST.V: No data found, symbol may be delisted\n",
      "- CUBI$C: No data found, symbol may be delisted\n",
      "- CTEST.E: No data found, symbol may be delisted\n",
      "- CTA$B: No data found, symbol may be delisted\n",
      "- CTA$A: No data found, symbol may be delisted\n",
      "- CTEST.O: No data found, symbol may be delisted\n",
      "- CTEST.G: No data found, symbol may be delisted\n",
      "- CUBI$E: No data found, symbol may be delisted\n",
      "- CUBI$D: No data found, symbol may be delisted\n",
      "- CTEST: 1d data not available for startTime=-2208988800 and endTime=1592829331. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- CTEST.L: No data found, symbol may be delisted\n",
      "- CUBI$F: No data found, symbol may be delisted\n",
      "- CRSAW: 1d data not available for startTime=-2208988800 and endTime=1592829331. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- CTXRW: 1d data not available for startTime=-2208988800 and endTime=1592829331. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- CTEST.S: No data found, symbol may be delisted\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "4 Failed downloads:\n",
      "- DCP$C: No data found, symbol may be delisted\n",
      "- DCP$B: No data found, symbol may be delisted\n",
      "- CYRXW: 1d data not available for startTime=-2208988800 and endTime=1592829340. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- CWEN.A: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "18 Failed downloads:\n",
      "- DFPHW: 1d data not available for startTime=-2208988800 and endTime=1592829343. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- DMYT.W: No data found, symbol may be delisted\n",
      "- DLR$G: No data found, symbol may be delisted\n",
      "- DLNG$A: No data found, symbol may be delisted\n",
      "- DMYT.U: No data found, symbol may be delisted\n",
      "- DLR$L: No data found, symbol may be delisted\n",
      "- DHR$A: No data found, symbol may be delisted\n",
      "- DFNS.U: No data found, symbol may be delisted\n",
      "- DLPNW: 1d data not available for startTime=-2208988800 and endTime=1592829344. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- DLR$J: No data found, symbol may be delisted\n",
      "- DLNG$B: No data found, symbol may be delisted\n",
      "- DHCNL: 1d data not available for startTime=-2208988800 and endTime=1592829345. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- DLR$C: No data found, symbol may be delisted\n",
      "- DKNGW: 1d data not available for startTime=-2208988800 and endTime=1592829345. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- DLR$I: No data found, symbol may be delisted\n",
      "- DHR$B: No data found, symbol may be delisted\n",
      "- DLR$K: No data found, symbol may be delisted\n",
      "- DFNS.W: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "11 Failed downloads:\n",
      "- DSKEW: 1d data not available for startTime=-2208988800 and endTime=1592829352. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- DS$D: No data found, symbol may be delisted\n",
      "- DS$C: No data found, symbol may be delisted\n",
      "- DPHCW: 1d data not available for startTime=-2208988800 and endTime=1592829353. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- DX$B: No data found, symbol may be delisted\n",
      "- DTLA$: No data found, symbol may be delisted\n",
      "- DS$B: No data found, symbol may be delisted\n",
      "- DRIOW: 1d data not available for startTime=-2208988800 and endTime=1592829355. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- DUK$A: No data found, symbol may be delisted\n",
      "- DX$C: No data found, symbol may be delisted\n",
      "- DSX$B: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "4 Failed downloads:\n",
      "- EFC$A: No data found, symbol may be delisted\n",
      "- EBR.B: No data found, symbol may be delisted\n",
      "- ECOLW: 1d data not available for startTime=-2208988800 and endTime=1592829361. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- ECF$A: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "10 Failed downloads:\n",
      "- EPR$E: No data found, symbol may be delisted\n",
      "- EPR$C: No data found, symbol may be delisted\n",
      "- ESSCW: 1d data not available for startTime=-2208988800 and endTime=1592829364. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- EP$C: No data found, symbol may be delisted\n",
      "- ESSCR: 1d data not available for startTime=-2208988800 and endTime=1592829364. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- EPR$G: No data found, symbol may be delisted\n",
      "- EQH$A: No data found, symbol may be delisted\n",
      "- EQC$D: No data found, symbol may be delisted\n",
      "- ENTXW: 1d data not available for startTime=-2208988800 and endTime=1592829366. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- ENR$A: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "10 Failed downloads:\n",
      "- F$C: No data found, symbol may be delisted\n",
      "- EYESW: 1d data not available for startTime=-2208988800 and endTime=1592829373. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- EVSIW: 1d data not available for startTime=-2208988800 and endTime=1592829374. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- ETP$D: No data found, symbol may be delisted\n",
      "- F$B: No data found, symbol may be delisted\n",
      "- EYEGW: 1d data not available for startTime=-2208988800 and endTime=1592829374. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- ETI$: No data found, symbol may be delisted\n",
      "- ETP$E: No data found, symbol may be delisted\n",
      "- ETP$C: No data found, symbol may be delisted\n",
      "- EXPCW: 1d data not available for startTime=-2208988800 and endTime=1592829376. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "5 Failed downloads:\n",
      "- FEAC.W: No data found, symbol may be delisted\n",
      "- FDUSL: 1d data not available for startTime=-2208988800 and endTime=1592829377. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- FHN$E: No data found, symbol may be delisted\n",
      "- FHN$A: No data found, symbol may be delisted\n",
      "- FEAC.U: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "11 Failed downloads:\n",
      "- FPAC.W: No data found, symbol may be delisted\n",
      "- FLMNW: 1d data not available for startTime=-2208988800 and endTime=1592829387. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- FRC$G: No data found, symbol may be delisted\n",
      "- FPAC.U: No data found, symbol may be delisted\n",
      "- FRC$I: No data found, symbol may be delisted\n",
      "- FPI$B: No data found, symbol may be delisted\n",
      "- FRC$H: No data found, symbol may be delisted\n",
      "- FMCIW: 1d data not available for startTime=-2208988800 and endTime=1592829389. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- FNB$E: No data found, symbol may be delisted\n",
      "- FRC$F: No data found, symbol may be delisted\n",
      "- FRC$J: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "13 Failed downloads:\n",
      "- FRT$C: No data found, symbol may be delisted\n",
      "- FSRVW: 1d data not available for startTime=-2208988800 and endTime=1592829396. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- GAB$G: No data found, symbol may be delisted\n",
      "- FVAC.U: No data found, symbol may be delisted\n",
      "- FTV$A: No data found, symbol may be delisted\n",
      "- GAB$K: No data found, symbol may be delisted\n",
      "- FTAI$B: No data found, symbol may be delisted\n",
      "- GAB$J: No data found, symbol may be delisted\n",
      "- GAB$H: No data found, symbol may be delisted\n",
      "- FTACW: 1d data not available for startTime=-2208988800 and endTime=1592829398. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- GBLIL: 1d data not available for startTime=-2208988800 and endTime=1592829399. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- GAM$B: No data found, symbol may be delisted\n",
      "- FTAI$A: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "21 Failed downloads:\n",
      "- GIX.U: No data found, symbol may be delisted\n",
      "- GEF.B: 1d data not available for startTime=-2208988800 and endTime=1592829405. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- GDV$G: No data found, symbol may be delisted\n",
      "- GECCL: 1d data not available for startTime=-2208988800 and endTime=1592829406. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- GECCM: 1d data not available for startTime=-2208988800 and endTime=1592829406. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- GDYNW: 1d data not available for startTime=-2208988800 and endTime=1592829406. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- GIX.W: No data found, symbol may be delisted\n",
      "- GDV$H: No data found, symbol may be delisted\n",
      "- GGO$A: No data found, symbol may be delisted\n",
      "- GFNSL: 1d data not available for startTime=-2208988800 and endTime=1592829407. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- GGZ$A: No data found, symbol may be delisted\n",
      "- GDL$C: No data found, symbol may be delisted\n",
      "- GGN$B: No data found, symbol may be delisted\n",
      "- GGT$E: No data found, symbol may be delisted\n",
      "- GDV$A: No data found, symbol may be delisted\n",
      "- GLEO.U: No data found, symbol may be delisted\n",
      "- GL$C: No data found, symbol may be delisted\n",
      "- GIX.R: No data found, symbol may be delisted\n",
      "- GIK.U: No data found, symbol may be delisted\n",
      "- GHIVW: 1d data not available for startTime=-2208988800 and endTime=1592829408. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- GGT$G: No data found, symbol may be delisted\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "17 Failed downloads:\n",
      "- GLU$A: No data found, symbol may be delisted\n",
      "- GLOG$A: No data found, symbol may be delisted\n",
      "- GLOP$A: No data found, symbol may be delisted\n",
      "- GNRSW: 1d data not available for startTime=-2208988800 and endTime=1592829415. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- GPAQW: 1d data not available for startTime=-2208988800 and endTime=1592829416. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- GMRE$A: No data found, symbol may be delisted\n",
      "- GLP$A: No data found, symbol may be delisted\n",
      "- GLU$B: No data found, symbol may be delisted\n",
      "- GLEO.W: No data found, symbol may be delisted\n",
      "- GMHIW: 1d data not available for startTime=-2208988800 and endTime=1592829416. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- GNT$A: No data found, symbol may be delisted\n",
      "- GMBLW: 1d data not available for startTime=-2208988800 and endTime=1592829417. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- GNE$A: No data found, symbol may be delisted\n",
      "- GNL$A: No data found, symbol may be delisted\n",
      "- GLOP$C: No data found, symbol may be delisted\n",
      "- GLOP$B: No data found, symbol may be delisted\n",
      "- GNL$B: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "18 Failed downloads:\n",
      "- GS$K: No data found, symbol may be delisted\n",
      "- GS$D: No data found, symbol may be delisted\n",
      "- GXGXW: 1d data not available for startTime=-2208988800 and endTime=1592829422. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- GS$J: No data found, symbol may be delisted\n",
      "- GS$A: No data found, symbol may be delisted\n",
      "- GSL$B: No data found, symbol may be delisted\n",
      "- GRX$B: No data found, symbol may be delisted\n",
      "- GRAF.U: No data found, symbol may be delisted\n",
      "- GRAF.W: No data found, symbol may be delisted\n",
      "- GRP.U: No data found, symbol may be delisted\n",
      "- GS$C: No data found, symbol may be delisted\n",
      "- GRNVW: 1d data not available for startTime=-2208988800 and endTime=1592829424. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- GSMGW: 1d data not available for startTime=-2208988800 and endTime=1592829425. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- GUT$C: No data found, symbol may be delisted\n",
      "- GUT$A: No data found, symbol may be delisted\n",
      "- GS$N: No data found, symbol may be delisted\n",
      "- GRNVR: 1d data not available for startTime=-2208988800 and endTime=1592829425. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- GTN.A: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "10 Failed downloads:\n",
      "- HFRO$A: No data found, symbol may be delisted\n",
      "- HCAPZ: 1d data not available for startTime=-2208988800 and endTime=1592829433. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- HEI.A: No data found, symbol may be delisted\n",
      "- HCCHR: 1d data not available for startTime=-2208988800 and endTime=1592829434. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- HCACW: 1d data not available for startTime=-2208988800 and endTime=1592829434. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- HCCOW: 1d data not available for startTime=-2208988800 and endTime=1592829435. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- HCCHW: 1d data not available for startTime=-2208988800 and endTime=1592829435. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- HIG$G: No data found, symbol may be delisted\n",
      "- HL$B: No data found, symbol may be delisted\n",
      "- HLM$: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "5 Failed downloads:\n",
      "- HSBC$A: No data found, symbol may be delisted\n",
      "- HT$E: No data found, symbol may be delisted\n",
      "- HT$D: No data found, symbol may be delisted\n",
      "- HT$C: No data found, symbol may be delisted\n",
      "- HMLP$A: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "8 Failed downloads:\n",
      "- HYMCW: 1d data not available for startTime=-2208988800 and endTime=1592829447. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- IGICW: 1d data not available for startTime=-2208988800 and endTime=1592829447. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- IEAWW: 1d data not available for startTime=-2208988800 and endTime=1592829448. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- HVT.A: No data found, symbol may be delisted\n",
      "- IGZ: 1d data not available for startTime=-2208988800 and endTime=1592829448. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- IBO: 1d data not available for startTime=-2208988800 and endTime=1592829449. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- HWM$: No data found, symbol may be delisted\n",
      "- HYACW: 1d data not available for startTime=-2208988800 and endTime=1592829450. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "11 Failed downloads:\n",
      "- IIPR$A: No data found, symbol may be delisted\n",
      "- IPOB.U: No data found, symbol may be delisted\n",
      "- INN$D: No data found, symbol may be delisted\n",
      "- IMRNW: 1d data not available for startTime=-2208988800 and endTime=1592829458. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- IPOC.U: No data found, symbol may be delisted\n",
      "- INN$E: No data found, symbol may be delisted\n",
      "- IPOC.W: No data found, symbol may be delisted\n",
      "- INSUW: 1d data not available for startTime=-2208988800 and endTime=1592829460. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- INSW$A: No data found, symbol may be delisted\n",
      "- IMACW: 1d data not available for startTime=-2208988800 and endTime=1592829462. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- IPOB.W: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "10 Failed downloads:\n",
      "- JFKKR: 1d data not available for startTime=-2208988800 and endTime=1592829469. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- IPV.U: No data found, symbol may be delisted\n",
      "- JE$A: No data found, symbol may be delisted\n",
      "- IRET$C: No data found, symbol may be delisted\n",
      "- IPV.W: No data found, symbol may be delisted\n",
      "- IVR$A: No data found, symbol may be delisted\n",
      "- JFKKW: 1d data not available for startTime=-2208988800 and endTime=1592829471. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- IVR$C: No data found, symbol may be delisted\n",
      "- JCAP$B: No data found, symbol may be delisted\n",
      "- IVR$B: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "17 Failed downloads:\n",
      "- JPM$G: No data found, symbol may be delisted\n",
      "- KBLMW: 1d data not available for startTime=-2208988800 and endTime=1592829473. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- KERNW: 1d data not available for startTime=-2208988800 and endTime=1592829473. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- KCAPL: 1d data not available for startTime=-2208988800 and endTime=1592829474. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- KBLMR: 1d data not available for startTime=-2208988800 and endTime=1592829474. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- JPM$H: No data found, symbol may be delisted\n",
      "- JW.A: No data found, symbol may be delisted\n",
      "- JIH.U: No data found, symbol may be delisted\n",
      "- KEY$J: No data found, symbol may be delisted\n",
      "- KEY$I: No data found, symbol may be delisted\n",
      "- JPM$J: No data found, symbol may be delisted\n",
      "- JIH.W: No data found, symbol may be delisted\n",
      "- JPM$D: No data found, symbol may be delisted\n",
      "- KEY$K: No data found, symbol may be delisted\n",
      "- JPM$C: No data found, symbol may be delisted\n",
      "- JWS.U: No data found, symbol may be delisted\n",
      "- JW.B: No data found, symbol may be delisted\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "8 Failed downloads:\n",
      "- KSU$: No data found, symbol may be delisted\n",
      "- KIM$M: No data found, symbol may be delisted\n",
      "- KLR.W: No data found, symbol may be delisted\n",
      "- KKR$A: No data found, symbol may be delisted\n",
      "- LACQW: 1d data not available for startTime=-2208988800 and endTime=1592829484. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- KKR$B: No data found, symbol may be delisted\n",
      "- KTOVW: 1d data not available for startTime=-2208988800 and endTime=1592829484. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- KIM$L: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "12 Failed downloads:\n",
      "- LGC.U: No data found, symbol may be delisted\n",
      "- LATNW: 1d data not available for startTime=-2208988800 and endTime=1592829488. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- LGC.W: No data found, symbol may be delisted\n",
      "- LFACW: 1d data not available for startTime=-2208988800 and endTime=1592829489. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- LHC.W: No data found, symbol may be delisted\n",
      "- LCAHW: 1d data not available for startTime=-2208988800 and endTime=1592829489. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- LGHLW: 1d data not available for startTime=-2208988800 and endTime=1592829490. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- LGVW.U: No data found, symbol may be delisted\n",
      "- LIVKW: 1d data not available for startTime=-2208988800 and endTime=1592829491. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- LGF.A: No data found, symbol may be delisted\n",
      "- LEN.B: 1d data not available for startTime=-2208988800 and endTime=1592829492. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- LHC.U: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "7 Failed downloads:\n",
      "- LMFAW: 1d data not available for startTime=-2208988800 and endTime=1592829492. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- LOAK.U: No data found, symbol may be delisted\n",
      "- LOACR: 1d data not available for startTime=-2208988800 and endTime=1592829494. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- LOAK.W: No data found, symbol may be delisted\n",
      "- LSACW: 1d data not available for startTime=-2208988800 and endTime=1592829496. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- LXP$C: No data found, symbol may be delisted\n",
      "- LOACW: 1d data not available for startTime=-2208988800 and endTime=1592829496. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "4 Failed downloads:\n",
      "- MDGSW: 1d data not available for startTime=-2208988800 and endTime=1592829503. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- MER$K: No data found, symbol may be delisted\n",
      "- MCMJW: 1d data not available for startTime=-2208988800 and endTime=1592829504. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- MAA$I: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "15 Failed downloads:\n",
      "- MKC.V: No data found, symbol may be delisted\n",
      "- MFA$B: No data found, symbol may be delisted\n",
      "- MH$A: No data found, symbol may be delisted\n",
      "- MET$E: No data found, symbol may be delisted\n",
      "- MET$F: No data found, symbol may be delisted\n",
      "- MFAC.U: No data found, symbol may be delisted\n",
      "- MH$D: No data found, symbol may be delisted\n",
      "- MITT$C: No data found, symbol may be delisted\n",
      "- MET$A: No data found, symbol may be delisted\n",
      "- MH$C: No data found, symbol may be delisted\n",
      "- MITT$A: No data found, symbol may be delisted\n",
      "- MFA$C: No data found, symbol may be delisted\n",
      "- METXW: 1d data not available for startTime=-2208988800 and endTime=1592829511. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- MITT$B: No data found, symbol may be delisted\n",
      "- MFAC.W: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "10 Failed downloads:\n",
      "- MNR$C: No data found, symbol may be delisted\n",
      "- MS$L: No data found, symbol may be delisted\n",
      "- MS$I: No data found, symbol may be delisted\n",
      "- MS$E: No data found, symbol may be delisted\n",
      "- MOG.B: No data found, symbol may be delisted\n",
      "- MS$A: No data found, symbol may be delisted\n",
      "- MS$K: No data found, symbol may be delisted\n",
      "- MOG.A: No data found, symbol may be delisted\n",
      "- MNCLW: 1d data not available for startTime=-2208988800 and endTime=1592829516. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- MS$F: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "1 Failed download:\n",
      "- MTL$: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "19 Failed downloads:\n",
      "- NEE$J: No data found, symbol may be delisted\n",
      "- NEE$P: No data found, symbol may be delisted\n",
      "- NBACR: 1d data not available for startTime=-2208988800 and endTime=1592829537. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- NEE$O: No data found, symbol may be delisted\n",
      "- NAV$D: No data found, symbol may be delisted\n",
      "- NCV$A: No data found, symbol may be delisted\n",
      "- NEWTI: 1d data not available for startTime=-2208988800 and endTime=1592829537. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- NEE$I: No data found, symbol may be delisted\n",
      "- NFINW: 1d data not available for startTime=-2208988800 and endTime=1592829537. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- NBACW: 1d data not available for startTime=-2208988800 and endTime=1592829537. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- NBR$A: No data found, symbol may be delisted\n",
      "- NGL$B: No data found, symbol may be delisted\n",
      "- NGL$C: No data found, symbol may be delisted\n",
      "- NDRAW: 1d data not available for startTime=-2208988800 and endTime=1592829539. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- NESRW: 1d data not available for startTime=-2208988800 and endTime=1592829539. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- NFH.W: No data found, symbol may be delisted\n",
      "- NEE$K: No data found, symbol may be delisted\n",
      "- NCZ$A: No data found, symbol may be delisted\n",
      "- NEE$N: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "15 Failed downloads:\n",
      "- NHLDW: 1d data not available for startTime=-2208988800 and endTime=1592829545. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- NMK$C: No data found, symbol may be delisted\n",
      "- NGLS$A: No data found, symbol may be delisted\n",
      "- NLY$F: No data found, symbol may be delisted\n",
      "- NI$B: No data found, symbol may be delisted\n",
      "- NKLAW: 1d data not available for startTime=-2208988800 and endTime=1592829546. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- NLY$D: No data found, symbol may be delisted\n",
      "- NLY$G: No data found, symbol may be delisted\n",
      "- NNN$F: No data found, symbol may be delisted\n",
      "- NLY$I: No data found, symbol may be delisted\n",
      "- NPAWW: 1d data not available for startTime=-2208988800 and endTime=1592829547. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- NOVSW: 1d data not available for startTime=-2208988800 and endTime=1592829547. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- NMK$B: No data found, symbol may be delisted\n",
      "- NM$G: No data found, symbol may be delisted\n",
      "- NM$H: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "14 Failed downloads:\n",
      "- NTEST.A: No data found, symbol may be delisted\n",
      "- NSCO.W: No data found, symbol may be delisted\n",
      "- NRZ$B: No data found, symbol may be delisted\n",
      "- NRZ$C: No data found, symbol may be delisted\n",
      "- NS$A: No data found, symbol may be delisted\n",
      "- NSPR.W: No data found, symbol may be delisted\n",
      "- NSA$A: No data found, symbol may be delisted\n",
      "- NS$B: No data found, symbol may be delisted\n",
      "- NTEST.C: No data found, symbol may be delisted\n",
      "- NTEST.B: No data found, symbol may be delisted\n",
      "- NRZ$A: No data found, symbol may be delisted\n",
      "- NS$C: No data found, symbol may be delisted\n",
      "- NSPR.B: No data found, symbol may be delisted\n",
      "- NTEST: 1d data not available for startTime=-2208988800 and endTime=1592829558. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "11 Failed downloads:\n",
      "- OAC.W: No data found, symbol may be delisted\n",
      "- OIBR.C: No data found, symbol may be delisted\n",
      "- NYCB$U: No data found, symbol may be delisted\n",
      "- OFG$D: No data found, symbol may be delisted\n",
      "- OAC.U: No data found, symbol may be delisted\n",
      "- OAK$A: No data found, symbol may be delisted\n",
      "- OFSSL: 1d data not available for startTime=-2208988800 and endTime=1592829566. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- OFG$A: No data found, symbol may be delisted\n",
      "- NYCB$A: No data found, symbol may be delisted\n",
      "- OFG$B: No data found, symbol may be delisted\n",
      "- OAK$B: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "6 Failed downloads:\n",
      "- OPESW: 1d data not available for startTime=-2208988800 and endTime=1592829574. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- ORSNW: 1d data not available for startTime=-2208988800 and endTime=1592829574. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- ORSNR: 1d data not available for startTime=-2208988800 and endTime=1592829575. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- ONTXW: 1d data not available for startTime=-2208988800 and endTime=1592829575. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- OTLKW: 1d data not available for startTime=-2208988800 and endTime=1592829576. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- OXBRW: 1d data not available for startTime=-2208988800 and endTime=1592829576. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "20 Failed downloads:\n",
      "- PAVMZ: 1d data not available for startTime=-2208988800 and endTime=1592829584. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- PACK.W: No data found, symbol may be delisted\n",
      "- PCG$E: No data found, symbol may be delisted\n",
      "- PCG$B: No data found, symbol may be delisted\n",
      "- PEB$F: No data found, symbol may be delisted\n",
      "- PCPL.U: No data found, symbol may be delisted\n",
      "- PCPL.W: No data found, symbol may be delisted\n",
      "- PCG$C: No data found, symbol may be delisted\n",
      "- PCG$I: No data found, symbol may be delisted\n",
      "- PAEWW: 1d data not available for startTime=-2208988800 and endTime=1592829585. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- PEB$D: No data found, symbol may be delisted\n",
      "- PCPL: 1d data not available for startTime=-2208988800 and endTime=1592829585. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- PCG$A: No data found, symbol may be delisted\n",
      "- PCG$H: No data found, symbol may be delisted\n",
      "- PBR.A: No data found, symbol may be delisted\n",
      "- PCG$D: No data found, symbol may be delisted\n",
      "- PBI$B: No data found, symbol may be delisted\n",
      "- PCG$G: No data found, symbol may be delisted\n",
      "- PEB$E: No data found, symbol may be delisted\n",
      "- PEB$C: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "9 Failed downloads:\n",
      "- PEI$B: No data found, symbol may be delisted\n",
      "- PEI$C: No data found, symbol may be delisted\n",
      "- PHGE.W: No data found, symbol may be delisted\n",
      "- PHIOW: 1d data not available for startTime=-2208988800 and endTime=1592829595. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- PIC.W: No data found, symbol may be delisted\n",
      "- PEI$D: No data found, symbol may be delisted\n",
      "- PHUNW: 1d data not available for startTime=-2208988800 and endTime=1592829596. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- PIC.U: No data found, symbol may be delisted\n",
      "- PHGE.U: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "15 Failed downloads:\n",
      "- PNC$Q: No data found, symbol may be delisted\n",
      "- PRE$G: No data found, symbol may be delisted\n",
      "- PLYM$A: No data found, symbol may be delisted\n",
      "- PMT$A: No data found, symbol may be delisted\n",
      "- PRIF$B: No data found, symbol may be delisted\n",
      "- PRE$F: No data found, symbol may be delisted\n",
      "- PMT$B: No data found, symbol may be delisted\n",
      "- PRIF$A: No data found, symbol may be delisted\n",
      "- PRE$I: No data found, symbol may be delisted\n",
      "- PRIF$C: No data found, symbol may be delisted\n",
      "- PRE$H: No data found, symbol may be delisted\n",
      "- PRIF$E: No data found, symbol may be delisted\n",
      "- PRIF$F: No data found, symbol may be delisted\n",
      "- PRIF$D: No data found, symbol may be delisted\n",
      "- PNC$P: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "22 Failed downloads:\n",
      "- PSA$X: No data found, symbol may be delisted\n",
      "- PTACW: 1d data not available for startTime=-2208988800 and endTime=1592829608. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- PSA$C: No data found, symbol may be delisted\n",
      "- PSA$V: No data found, symbol may be delisted\n",
      "- PSA$I: No data found, symbol may be delisted\n",
      "- PSB$Z: No data found, symbol may be delisted\n",
      "- PSA$W: No data found, symbol may be delisted\n",
      "- PSA$J: No data found, symbol may be delisted\n",
      "- PSA$F: No data found, symbol may be delisted\n",
      "- PW$A: No data found, symbol may be delisted\n",
      "- PSA$E: No data found, symbol may be delisted\n",
      "- PUK$A: No data found, symbol may be delisted\n",
      "- PSA$H: No data found, symbol may be delisted\n",
      "- PSB$Y: No data found, symbol may be delisted\n",
      "- PSA$K: No data found, symbol may be delisted\n",
      "- PSB$W: No data found, symbol may be delisted\n",
      "- PSA$B: No data found, symbol may be delisted\n",
      "- PSB$X: No data found, symbol may be delisted\n",
      "- PUK$: No data found, symbol may be delisted\n",
      "- PSA$L: No data found, symbol may be delisted\n",
      "- PSA$D: No data found, symbol may be delisted\n",
      "- PSA$G: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "4 Failed downloads:\n",
      "- QTS$A: No data found, symbol may be delisted\n",
      "- RDS.A: No data found, symbol may be delisted\n",
      "- QTS$B: No data found, symbol may be delisted\n",
      "- RDS.B: 1d data not available for startTime=-2208988800 and endTime=1592829614. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "11 Failed downloads:\n",
      "- RMG.W: No data found, symbol may be delisted\n",
      "- RF$C: No data found, symbol may be delisted\n",
      "- RMPL$: No data found, symbol may be delisted\n",
      "- RMG.U: No data found, symbol may be delisted\n",
      "- REXR$A: No data found, symbol may be delisted\n",
      "- REXR$B: No data found, symbol may be delisted\n",
      "- RLJ$A: No data found, symbol may be delisted\n",
      "- REXR$C: No data found, symbol may be delisted\n",
      "- RHE$A: No data found, symbol may be delisted\n",
      "- RF$B: No data found, symbol may be delisted\n",
      "- RF$A: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "11 Failed downloads:\n",
      "- ROCHW: No data found, symbol may be delisted\n",
      "- RPLA.U: No data found, symbol may be delisted\n",
      "- ROCH: No data found, symbol may be delisted\n",
      "- RNR$E: No data found, symbol may be delisted\n",
      "- RPT$D: No data found, symbol may be delisted\n",
      "- SAMAW: 1d data not available for startTime=-2208988800 and endTime=1592829633. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- ROSEW: 1d data not available for startTime=-2208988800 and endTime=1592829634. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- RPTX: 1d data not available for startTime=-2208988800 and endTime=1592829634. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- RNR$F: No data found, symbol may be delisted\n",
      "- RY$T: No data found, symbol may be delisted\n",
      "- RPLA.W: No data found, symbol may be delisted\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "21 Failed downloads:\n",
      "- SB$C: No data found, symbol may be delisted\n",
      "- SBE.W: No data found, symbol may be delisted\n",
      "- SCVX.W: No data found, symbol may be delisted\n",
      "- SBE.U: No data found, symbol may be delisted\n",
      "- SCPE.W: No data found, symbol may be delisted\n",
      "- SCE$H: No data found, symbol may be delisted\n",
      "- SCHW$D: No data found, symbol may be delisted\n",
      "- SB$D: No data found, symbol may be delisted\n",
      "- SCPE.U: No data found, symbol may be delisted\n",
      "- SAN$B: No data found, symbol may be delisted\n",
      "- SCE$D: No data found, symbol may be delisted\n",
      "- SAQNW: 1d data not available for startTime=-2208988800 and endTime=1592829638. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- SCVX.U: No data found, symbol may be delisted\n",
      "- SCE$G: No data found, symbol may be delisted\n",
      "- SCHW$C: No data found, symbol may be delisted\n",
      "- SCE$C: No data found, symbol may be delisted\n",
      "- SCE$J: No data found, symbol may be delisted\n",
      "- SCE$K: No data found, symbol may be delisted\n",
      "- SCE$B: No data found, symbol may be delisted\n",
      "- SCE$E: No data found, symbol may be delisted\n",
      "- SCE$L: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "15 Failed downloads:\n",
      "- SFB: 1d data not available for startTime=-2208988800 and endTime=1592829640. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- SHO$F: No data found, symbol may be delisted\n",
      "- SFTW.W: No data found, symbol may be delisted\n",
      "- SF$A: No data found, symbol may be delisted\n",
      "- SF$B: No data found, symbol may be delisted\n",
      "- SHO$E: No data found, symbol may be delisted\n",
      "- SHIPZ: 1d data not available for startTime=-2208988800 and endTime=1592829642. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- SGLBW: 1d data not available for startTime=-2208988800 and endTime=1592829642. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- SFTW.U: No data found, symbol may be delisted\n",
      "- SHIPW: 1d data not available for startTime=-2208988800 and endTime=1592829642. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- SHLL.U: No data found, symbol may be delisted\n",
      "- SF$C: No data found, symbol may be delisted\n",
      "- SITC$K: No data found, symbol may be delisted\n",
      "- SHLL.W: No data found, symbol may be delisted\n",
      "- SITC$A: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "7 Failed downloads:\n",
      "- SNV$E: No data found, symbol may be delisted\n",
      "- SLG$I: No data found, symbol may be delisted\n",
      "- SNGXW: 1d data not available for startTime=-2208988800 and endTime=1592829646. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- SOAC.U: No data found, symbol may be delisted\n",
      "- SOLOW: 1d data not available for startTime=-2208988800 and endTime=1592829647. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- SMMCW: 1d data not available for startTime=-2208988800 and endTime=1592829648. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- SNV$D: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "16 Failed downloads:\n",
      "- STAR$I: No data found, symbol may be delisted\n",
      "- SPE$B: No data found, symbol may be delisted\n",
      "- STAR$G: No data found, symbol may be delisted\n",
      "- SR$A: No data found, symbol may be delisted\n",
      "- SSPKW: 1d data not available for startTime=-2208988800 and endTime=1592829656. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- SPAQ.W: No data found, symbol may be delisted\n",
      "- SRACW: 1d data not available for startTime=-2208988800 and endTime=1592829657. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- SRE$A: No data found, symbol may be delisted\n",
      "- SRG$A: No data found, symbol may be delisted\n",
      "- SPLP$A: No data found, symbol may be delisted\n",
      "- SPG$J: No data found, symbol may be delisted\n",
      "- STAG$C: No data found, symbol may be delisted\n",
      "- SRE$B: No data found, symbol may be delisted\n",
      "- SRC$A: No data found, symbol may be delisted\n",
      "- STAR$D: No data found, symbol may be delisted\n",
      "- SPAQ.U: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "8 Failed downloads:\n",
      "- T$C: No data found, symbol may be delisted\n",
      "- SYF$A: No data found, symbol may be delisted\n",
      "- STL$A: No data found, symbol may be delisted\n",
      "- STZ.B: 1d data not available for startTime=-2208988800 and endTime=1592829665. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- TACOW: 1d data not available for startTime=-2208988800 and endTime=1592829665. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- T$A: No data found, symbol may be delisted\n",
      "- STT$G: No data found, symbol may be delisted\n",
      "- STT$D: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "13 Failed downloads:\n",
      "- TFC$O: No data found, symbol may be delisted\n",
      "- TDACW: 1d data not available for startTime=-2208988800 and endTime=1592829669. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- TFC$I: No data found, symbol may be delisted\n",
      "- TAP.A: No data found, symbol may be delisted\n",
      "- TDW.A: No data found, symbol may be delisted\n",
      "- TFC$F: No data found, symbol may be delisted\n",
      "- TALO.W: No data found, symbol may be delisted\n",
      "- TCO$K: No data found, symbol may be delisted\n",
      "- TFC$G: No data found, symbol may be delisted\n",
      "- TFC$H: No data found, symbol may be delisted\n",
      "- TDW.B: 1d data not available for startTime=-2208988800 and endTime=1592829673. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- TDW.W: No data found, symbol may be delisted\n",
      "- TCO$J: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "12 Failed downloads:\n",
      "- THCAW: 1d data not available for startTime=-2208988800 and endTime=1592829679. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- TNP$D: No data found, symbol may be delisted\n",
      "- TNP$E: No data found, symbol may be delisted\n",
      "- TGP$B: No data found, symbol may be delisted\n",
      "- TNP$C: No data found, symbol may be delisted\n",
      "- TNP$F: No data found, symbol may be delisted\n",
      "- TGP$A: No data found, symbol may be delisted\n",
      "- THWWW: 1d data not available for startTime=-2208988800 and endTime=1592829681. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- TOTAR: 1d data not available for startTime=-2208988800 and endTime=1592829682. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- THBRW: 1d data not available for startTime=-2208988800 and endTime=1592829682. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- THCBW: 1d data not available for startTime=-2208988800 and endTime=1592829682. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- TOTAW: 1d data not available for startTime=-2208988800 and endTime=1592829682. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "7 Failed downloads:\n",
      "- TRTN$C: No data found, symbol may be delisted\n",
      "- TRNE.U: No data found, symbol may be delisted\n",
      "- TRTN$D: No data found, symbol may be delisted\n",
      "- TRNE.W: No data found, symbol may be delisted\n",
      "- TRTN$A: No data found, symbol may be delisted\n",
      "- TRTN$B: No data found, symbol may be delisted\n",
      "- TREB.U: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "12 Failed downloads:\n",
      "- TWO$B: No data found, symbol may be delisted\n",
      "- TWO$D: No data found, symbol may be delisted\n",
      "- TY$: No data found, symbol may be delisted\n",
      "- UBP$H: No data found, symbol may be delisted\n",
      "- TZACW: 1d data not available for startTime=-2208988800 and endTime=1592829695. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- TWO$A: No data found, symbol may be delisted\n",
      "- UMH$C: No data found, symbol may be delisted\n",
      "- UMH$D: No data found, symbol may be delisted\n",
      "- TWO$E: No data found, symbol may be delisted\n",
      "- UBP$K: No data found, symbol may be delisted\n",
      "- UMH$B: No data found, symbol may be delisted\n",
      "- TWO$C: No data found, symbol may be delisted\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "10 Failed downloads:\n",
      "- VERBW: 1d data not available for startTime=-2208988800 and endTime=1592829704. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- VER$F: No data found, symbol may be delisted\n",
      "- VERT.U: No data found, symbol may be delisted\n",
      "- USB$P: No data found, symbol may be delisted\n",
      "- USWSW: 1d data not available for startTime=-2208988800 and endTime=1592829705. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- USB$A: No data found, symbol may be delisted\n",
      "- USB$M: No data found, symbol may be delisted\n",
      "- USB$H: No data found, symbol may be delisted\n",
      "- USB$O: No data found, symbol may be delisted\n",
      "- UUUU.W: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "9 Failed downloads:\n",
      "- VNO$K: No data found, symbol may be delisted\n",
      "- VKTXW: 1d data not available for startTime=-2208988800 and endTime=1592829714. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- VVNT.W: No data found, symbol may be delisted\n",
      "- VNO$M: No data found, symbol may be delisted\n",
      "- VNO$L: No data found, symbol may be delisted\n",
      "- VOYA$B: No data found, symbol may be delisted\n",
      "- VRMEW: 1d data not available for startTime=-2208988800 and endTime=1592829716. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- VRT.W: No data found, symbol may be delisted\n",
      "- VST.A: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "13 Failed downloads:\n",
      "- WFC$Y: No data found, symbol may be delisted\n",
      "- WFC$R: No data found, symbol may be delisted\n",
      "- WFC$V: No data found, symbol may be delisted\n",
      "- WFC$P: No data found, symbol may be delisted\n",
      "- WFC$Z: No data found, symbol may be delisted\n",
      "- WBS$F: No data found, symbol may be delisted\n",
      "- WFC$X: No data found, symbol may be delisted\n",
      "- WFC$L: No data found, symbol may be delisted\n",
      "- WFC$N: No data found, symbol may be delisted\n",
      "- WFC$T: No data found, symbol may be delisted\n",
      "- WFC$O: No data found, symbol may be delisted\n",
      "- WFC$Q: No data found, symbol may be delisted\n",
      "- WFC$W: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  100 of 100 completed\n",
      "\n",
      "10 Failed downloads:\n",
      "- WRB$C: No data found, symbol may be delisted\n",
      "- WRB$D: No data found, symbol may be delisted\n",
      "- WRB$B: No data found, symbol may be delisted\n",
      "- WPG$I: No data found, symbol may be delisted\n",
      "- WPF.U: No data found, symbol may be delisted\n",
      "- WRB$E: No data found, symbol may be delisted\n",
      "- XAN$C: No data found, symbol may be delisted\n",
      "- WPG$H: No data found, symbol may be delisted\n",
      "- WRB$F: No data found, symbol may be delisted\n",
      "- WSO.B: No data found, symbol may be delisted\n",
      "[*********************100%***********************]  93 of 93 completed\n",
      "\n",
      "19 Failed downloads:\n",
      "- ZXYZ.A: No data found, symbol may be delisted\n",
      "- ZBZX: 1d data not available for startTime=-2208988800 and endTime=1592829734. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- ZTEST: 1d data not available for startTime=-2208988800 and endTime=1592829734. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- ZVZZT: 1d data not available for startTime=-2208988800 and endTime=1592829734. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- ZVV: 1d data not available for startTime=-2208988800 and endTime=1592829734. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- ZXIET: No data found, symbol may be delisted\n",
      "- ZBZZT: 1d data not available for startTime=-2208988800 and endTime=1592829735. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- ZNWAA: 1d data not available for startTime=-2208988800 and endTime=1592829735. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- ZGYHW: 1d data not available for startTime=-2208988800 and endTime=1592829735. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- ZAZZT: 1d data not available for startTime=-2208988800 and endTime=1592829735. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- YCBD$A: No data found, symbol may be delisted\n",
      "- ZEXIT: No data found, symbol may be delisted\n",
      "- ZJZZT: 1d data not available for startTime=-2208988800 and endTime=1592829735. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- ZIEXT: No data found, symbol may be delisted\n",
      "- ZXZZT: 1d data not available for startTime=-2208988800 and endTime=1592829736. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- ZWZZT: 1d data not available for startTime=-2208988800 and endTime=1592829736. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- ZVZZC: 1d data not available for startTime=-2208988800 and endTime=1592829736. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- ZCZZT: 1d data not available for startTime=-2208988800 and endTime=1592829736. Only 100 years worth of day granularity data are allowed to be fetched per request.\n",
      "- ZGYHR: 1d data not available for startTime=-2208988800 and endTime=1592829736. Only 100 years worth of day granularity data are allowed to be fetched per request.\n"
     ]
    }
   ],
   "source": [
    "prices_adj = []\n",
    "with pd.HDFStore('chunks.h5') as store:\n",
    "    for i, chunk in enumerate(chunks(all_tickers, 100)):\n",
    "        print(i, end=' ', flush=True)\n",
    "        prices_adj.append(yf.download(chunk, period='max', auto_adjust=True).stack(-1))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-22T12:42:48.938951Z",
     "start_time": "2020-06-22T12:42:21.147849Z"
    }
   },
   "outputs": [],
   "source": [
    "prices_adj = (pd.concat(prices_adj)\n",
    "              .dropna(how='all', axis=1)\n",
    "              .rename(columns=str.lower)\n",
    "              .swaplevel())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-22T12:42:48.943275Z",
     "start_time": "2020-06-22T12:42:48.940216Z"
    }
   },
   "outputs": [],
   "source": [
    "prices_adj.index.names = ['ticker', 'date']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-22T12:42:49.054745Z",
     "start_time": "2020-06-22T12:42:48.944739Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "5879"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(prices_adj.index.unique('ticker'))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Remove outliers"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-22T12:42:55.950116Z",
     "start_time": "2020-06-22T12:42:49.055682Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "696"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = prices_adj.close.unstack('ticker')\n",
    "pmax = df.pct_change().max()\n",
    "pmin = df.pct_change().min()\n",
    "to_drop = pmax[pmax > 1].index.union(pmin[pmin<-1].index)\n",
    "len(to_drop)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-22T12:44:09.420865Z",
     "start_time": "2020-06-22T12:42:55.951123Z"
    }
   },
   "outputs": [],
   "source": [
    "prices_adj = prices_adj.drop(to_drop, level='ticker')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-22T12:44:09.513655Z",
     "start_time": "2020-06-22T12:44:09.421753Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "5183"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(prices_adj.index.unique('ticker'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-06-22T12:44:16.488306Z",
     "start_time": "2020-06-22T12:44:09.515666Z"
    }
   },
   "outputs": [],
   "source": [
    "prices_adj.sort_index().loc[idx[:, '1990': '2019'], :].to_hdf(results_path / 'data.h5', \n",
    "                                                              'stocks/prices/adjusted')"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python [conda env:ml4t-dl]",
   "language": "python",
   "name": "conda-env-ml4t-dl-py"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.7"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": true,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": true
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}
